topic Re: Can i use Apply map function if tables having more than two columns in QlikView

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

Tue, 23 Sep 2014 06:31:09 GMT

Hi,

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

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

ashfaq_haseeb — Tue, 23 Sep 2014 06:34:36 GMT

Yes,

You have to use two (multiple) mapping loads

At a time it just support one ID and one mapping

regards

ashfaq

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

tresB — Tue, 23 Sep 2014 06:37:07 GMT

Or, you can simply Join them.

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

vinay_hg — Tue, 23 Sep 2014 06:37:16 GMT

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

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

amit_saini — Tue, 23 Sep 2014 06:39:16 GMT

Sandhya,

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

Attached is example.

Thanks,

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

Colin-Albert — Tue, 23 Sep 2014 06:39:33 GMT

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.

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

alkesh_sharma — Tue, 23 Sep 2014 06:39:46 GMT

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

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

jagan — Tue, 23 Sep 2014 06:46:59 GMT

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.

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

Tue, 23 Sep 2014 07:09:02 GMT

Can u give any Example Application.

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

marksmunich — Tue, 23 Sep 2014 07:11:15 GMT

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