Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
i did it in same way,but am nt getting any result after aplication reload
dont know why?
actly its nt reaching till there,
Please share the tables
Hi,
Means you want the such a values in 1 table where all y values are uncommon in all three 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
];
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 ;
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.
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