Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

Re: concatenating tables

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;

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)
Highlighted
Creator
Creator

Re: concatenating tables

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

dont know why?

actly its nt reaching till there,

Highlighted

Re: concatenating tables

Please share the tables

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)
Highlighted
Specialist
Specialist

Re: concatenating tables

Hi,

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

Highlighted
Creator II
Creator II

Re: concatenating tables

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

Re: concatenating tables

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 ;

Highlighted
Champion III
Champion III

Re: concatenating tables

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.

Highlighted
Master
Master

Re: concatenating tables

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