Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Shahzad_Ahsan
Contributor II

How to map data from two columns of a table to one

Hi Freinds

I am stuck in a problem.

I have two tables. lets say T1 and T2 like this

T1:

SubIdMainId
01
02
03
94
105
06

 

T2:

MainId
1
2
3
4
5
6

 

Result I need:

MainId
1
2
3
4
5
6
9
10

 

I want to get all the values from  "SubId" which are not 0 in the new table.

 

Thank You

1 Reply
skamath1_metlif
Contributor II

Re: How to map data from two columns of a table to one

The requirement is not clear. Should the field name in T2 be SubId and the result table should be SubId instead of MainId?