Qliksense joins and concatenation

[andrea0901]

Hi All,

 i have requirement as below:

2 tables with no common columns present. However, in one table there is a column called ABC and in another table called XYZ where for both the columns the values are same. 

so i need to combine these two columns and kept as one column in frontend to get all the values from both the columns. 

i have done concatenation but i am getting circular loops, and if i did join in frontend i am not getting the values. 

please help me how to proceed. 

Thanks in advance. 

[hic]

The following should do it:

Data:
Load ABC as Key, ... From Source1 (...);
Concatenate (Data)
Load XYZ as Key, ... From Source2 (...);

If you get circular references, there must be other tables that interact with the above.

[andrea0901]

its not working. 

i will tell you the exact requirement. 

my main table is T1 which has ID and ABC

the second table is T2 which has XYZ. ABC and ZYZ column values are same and i need to merge into one. 

So what i did is:

T1:

load 

ID,

ABC as key

from (...)

Left join (T1)

Load XYZ as key

from (..)

The key has all the values but for the ID the other columns are not appearing.