Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
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

Labels (1)
1 Solution

Accepted Solutions
h_prakash
Contributor

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

Hi,

Just a small correction

select mainID

from table2

concatenate

select Subid as mainID

from table1 where Sunid<>0

Thanks

Prakash

3 Replies
Highlighted
Channa
Valued Contributor III

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

select mainID from table2

concatenate

select Subid from table1 where Sunid<>0

Channa
h_prakash
Contributor

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

Hi,

Just a small correction

select mainID

from table2

concatenate

select Subid as mainID

from table1 where Sunid<>0

Thanks

Prakash

Shahzad_Ahsan
Contributor II

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

Hi @h_prakash  

Thanks for the solution