Can i use Apply map function if tables having more than two columns

[#1]

Hi,

Can any one suggest Apply map function can be used if two tables having more than two columns.

[ashfaq_haseeb]

Yes,

You have to use two (multiple) mapping loads

At a time it just support one ID and one mapping

regards

ashfaq

[tresesco]

Or, you can simply Join them.

[vinay_hg]

yes u should use nested mapping. in applymap inside one more applymap or by usinf if condn

[amit_saini]

Sandhya,

Yes very much possible, as suggested by Ashfaq you need to go with two mapping loads.

Attached is example.

Thanks,

AS

[Colin-Albert]

Mapping tables and applymap only support two column tables. If you have three columns to map you can use two mapping tables. Although this sounds like more work it is easy to add and performs well during reloads.

[alkesh_sharma]

Yes but you need to write separate Mapping load for each and every column.

[jagan]

Hi,

Can you come up with some sample data and your expected output so that it would be easier to understand your requirement.

If you looking for a lookup with more than two columns in a table then use Lookup() in script.  refer below link

Lookup function

If you want to double mapping then use nested applymap() like below

LOAD

*,

ApplyMap('Table2', ApplyMap('Table1', Value1)) AS MappedValue

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[#9]

Can u give any Example Application.

[marksmunich]

Better post a sample application with your sample data. we can help you out with applymap. Just descibe what exactly you Need.