Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Mapping or join

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

32 Replies
bharatkishore
Creator III
Creator III
Author

No Same category field is missing...

kakani87
Specialist
Specialist

Cat.png

bharatkishore
Creator III
Creator III
Author

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

Te.PNG

qlik4asif
Creator III
Creator III

I have changed code

PFA

View solution in original post

bharatkishore
Creator III
Creator III
Author

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
Creator III
Creator III

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
Specialist
Specialist

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
Creator III
Creator III
Author

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
Creator III
Creator III

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

And also it is not mandatory to give

bharatkishore
Creator III
Creator III
Author

Thanks a lot saikishore...