Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I use a intervalmatch to create a mapping table for all common or uncommon value

table 1:

col1:

Value1,

value2,

value3

value5

....

col2:

value2

value3

value4

....

final mapping table should have all of them.

value1,

value2

value3

value5

Can you advise?

1 Reply
prieper
Master II
Master II

I don't quite understand the question. Do you wish to see all values (1,2,3,4,5)? Then you may use JOIN. Otherwise you have repeated same data as in col1.

Peter