Mapping or join

[bharatkishore]

Hi All,

I have two tables.

In one table i have A,B,C,D.....K

In second table i have A,B,C,D,L.

Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.

Now for this what i need to do join or link the tables or Mapping.. I am not sure.

Can you please help me on this.

Thanks,

Bharat

[bharatkishore]

No Same category field is missing...

[kakani87]

[bharatkishore]

this is before refresh.. he asked me to comment my code then refresh with his code.. after refresh i got the below one:

[qlik4asif · Accepted solution]

I have changed code

PFA

[bharatkishore]

Thanks a lot.... Thank you so much.

1)Can you tell me about autonumber why u have used

2) what gives for this one ApplyMap('Final_Category',Key,'Nodata') as Category like what s key and nodata means..

please..

[qlik4asif]

After creating composite key , it is better to use autonumber()

Autonumber is nothing but number representation for each unique key.

Always number search is better than String search.

@ !

Coming to mapping i am bringing the Lookup value(category) with respect to lookup field(Key)to other table.

After mapping , table will automatically drop

For better understanding see Mapping concept

[kakani87]

ApplyMap('Final_Category',Key,'Nodata') as Category

Maps field Key in table 'Final_Category' and 'Final_Overview'  and returns Category if category is not availabe then this will show category as 'Nodata'

here Final_Category table is considered as Mapping table with Keyword Mapping added to it.

How does Autonumber function work? | Qlik Community

[bharatkishore]

thank you so much.. in Apply map you have used ApplyMap('Final_Category',Key,'NoData')  no data menas for that composite key combination if there is no value it will be nodata. Am i correct ..

[qlik4asif]

Yes.....In place of no data you can write anything

And also it is not mandatory to give

[bharatkishore]

Thanks a lot saikishore...