Table Source

[risabhroy_03]

I have an ApplyMap statement that tells me the Supplier name.

So, basically, my Applymap gives me data from a mapping table and if the data is not found then it goes to table B and directly picks the data.

I want a new column that tells me from which table the Supplier name is coming.

Can anyone help me out?

Below is my Mapping Table (A)

 And below is my table B

And this is my Applymap statement

[justISO]

Hi, maybe just add additional row for 'flag' in both load scripts, for example:

'map' as flag

in mapping table so your loading script part will look like this:

[Map_Supplier]:
Mapping
Load
...
"T$OTBP" as [OTBP_010]
'map' as flag
FROM [$(v...

and add

'table' as flag

in table B loading script

[risabhroy_03]

No it will not work because it gives an error - Mapping table can have exactly 2 fields.

[vinieme12]

Syntax as below

If(Len(applymap('mappingtable',key,null())),'FromMappingTable','MainTable') as SupplierSource