Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

concatenating tables

i have x,y fields in one table

x,y in second table

x,y in third table

now i want to combine all these 3 tables into 1 on the basis of x field

where value for y field in all the three tables are different ,

so i want a combined value in one table,

how to achieve the same.

8 Replies
Anil_Babu_Samineni

What if you are given something like below? Check the model

Load x,y from Table1;

Join

Load x,y from Table2;

Join

Load x,y from Table3;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

i did it in same way,but am nt getting any result after aplication reload

dont know why?

actly its nt reaching till there,

Anil_Babu_Samineni

Please share the tables

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Specialist
Specialist

Hi,

Means you want the such a values in 1 table where all y values are uncommon in all three tables?

Anonymous
Not applicable
Author

LOAD * INLINE [

    emp, sal

    1, 11

    2, 22

    3, 33

    4, 44

    5, 55

];

join

LOAD * INLINE [

    emp, sal

    2, 122

    3, 133

    4, 144

    5, 155

    6, 166

];

join

LOAD * INLINE [

    emp, sal

   

    3, 233

    4, 244

    5, 255

    6, 266

    7,277

];output.PNG

Colin-Albert

If the three table have exactly the same field names, then the data will concatenate to a single table automatically unless you use the NoConcatenate command.

So just load from the 3 tables and Qlik will concatenate the data to a single table without the need to specify any join or concatenate command.

e.g.

Table:

load x, y from table1 ;

load x,y from table2 ;

load x,y from table3 ;

vishsaggi
Champion III
Champion III

Can you share your actual script which you are running? If you have 3 tables with same column names and same number of fields you can use concatenate like :

Load x,y from Table1;

Concatenate

Load x,y from Table2;

Concatenate

Load x,y from Table3;

This will combine all the rows from table2 and table3 into table1. So you can see one single table. If you want to join all the three tables see individual tables in your data model then use Keep.

effinty2112
Master
Master

Hi,

I'm not 100% sure what you mean by "where value for y field in all the three tables are different"

Maybe

Table1:

load x, y from table1 ;

load x,y from table2 ;

load x,y from table3 ;

Noconcatenate

DistinctTable;

Load Distinct * Resident Table;

Drop Table Table1;

Regards

Andrew