Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ..
I'm having two tables
Tab1:
Itemfamilycode
,Itemcode
Tab2:
Itemcode
,sale
,date
,branch
Now i want to get itemfamilycode into tab2
so using applymap() like below syntax
Tab1:
Mapping Load
Itemfamilycode
,Itemcode
Tab2:
Itemcode
,applymap('Tab1',Itemcode) as Itemfamilycode
,sale
,date
,branch
But Itemcode able to get in place of Itemfamilycode
any help in getting Itemfamilycode into tab2
Regards,
Kakani.
It's the other way around, in the MAPPING table always put first the value to be looked up, in this case, Itemcode, and the second, the value you want to have returned, in this case, Itemfamilycode. If there is no match, then the original Itemcode will be displayed. To avoid it, you can use a third parameter in ApplyMap()
ApplyMap('Tab1', Itemcode, 'N/A') AS Itemfamilycode
If Itemcode does not have a match in Tab1, the field will store "N/A" instead.
It's the other way around, in the MAPPING table always put first the value to be looked up, in this case, Itemcode, and the second, the value you want to have returned, in this case, Itemfamilycode. If there is no match, then the original Itemcode will be displayed. To avoid it, you can use a third parameter in ApplyMap()
ApplyMap('Tab1', Itemcode, 'N/A') AS Itemfamilycode
If Itemcode does not have a match in Tab1, the field will store "N/A" instead.
Yes the mistake I'm doing is putting lookup field in the send row
thank you for correcting me