topic Re: concatenating tables in QlikView

concatenating tables

Anonymous — Wed, 09 Aug 2017 11:12:51 GMT

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.

Re: concatenating tables

Anil_Babu_Samineni — Wed, 09 Aug 2017 11:19:10 GMT

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;

Re: concatenating tables

Anonymous — Wed, 09 Aug 2017 11:27:25 GMT

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

dont know why?

actly its nt reaching till there,

Re: concatenating tables

Anil_Babu_Samineni — Wed, 09 Aug 2017 11:30:20 GMT

Please share the tables

Re: concatenating tables

neha_shirsath — Wed, 09 Aug 2017 11:31:56 GMT

Hi,

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

Re: concatenating tables

Anonymous — Wed, 09 Aug 2017 11:48:56 GMT

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

];

Re: concatenating tables

Colin-Albert — Wed, 09 Aug 2017 12:16:16 GMT

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 ;

Re: concatenating tables

vishsaggi — Wed, 09 Aug 2017 14:19:44 GMT

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.

Re: concatenating tables

effinty2112 — Wed, 09 Aug 2017 14:24:48 GMT

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