Discussion board where members can get started with Qlik Sense.
I have 3 tables as drawn below:
Now my requirement is to get a 4th Table as drawn below after merging the above 3 tables.
Load * from Table1;
Load * from Table2;
Load * from Table3;
Load Distinct * resident Data;
Drop table Data;
This should produce the desired result:
T0: LOAD * INLINE [
Student Subjects Books
A 2 2
C 3 2
] (delimiter is spaces);
CONCATENATE LOAD * INLINE [
B 3 2
Max(Subjects) AS Subjects,
Only(Books) AS Books
DROP TABLE T1;
The CONCATENATE prefix is really not necessary as all the fields in the first three loads are identical.
LastValue(Subjects) as Subjects
instead of Max()
In my tables there are around 76 fields but the values differ in only one field.
So should I modify the code provided by you?