concatenating tables

[Anonymous]

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.

[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;

[Anonymous]

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

[neha_shirsath]

Hi,

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

[Anonymous]

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

];

[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]

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]

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