Values of mapping

VanshikaSingh

Module 1: Item module with List applied SKU2. Line item : "Entries" with list format: SKU List.

In Module 2: Item Module2 , with List applied SKU List , Line Item, "Entries" with list format : SKU2 List , "Code": Text.

I need to get the values that i mapped in module 1 . Basically reverse Lookup.

Like Output:

Items	Entries	Code
A	A1	A
B	A2	B
C	A3	C
D	A4	D
E	A5	E
F	A6	F
G	A7	G
H	A8	H

Thanks in Advance!

HimanshuRaj

@VanshikaSingh

You can use firstnonblank to pull data into 2nd module. But what values would you be pulling in against SKU A & B as:

SKU A maps to A1, A9

SKU B maps to A2. A10

You can only fetch one. How do you define it?

Cheers!!