Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have two correlated tables by 3 fields (field1, field2, field3):
TableA:
field1 | field2 | field3 | field4 |
A | Z | aaa | 25 |
B | Y | aaa | 10 |
A | Y | bbb | 20 |
TableB:
field1 | field2 | field3 | field5 |
A | Z | aaa | 4 |
B | Y | aaa | 5 |
M | Z | bbb | 6 |
If I upload both tables, Qlik automatically creates a $syn key with the three fields. I know one option is to create a new key as filed1&field2&field3 and upload theese field values only in one table (i.e.: TableA). The problem is that there are common filed1&field2&field3 between the two tables, but there are some filed1&field2&field3 that are in tableA and not in tableB (or in tableB and not in tableA), son I can't solve it creating this new key.
I want to avoid creating a 3rd table with all the combinations of filed1&field2&field3 because of the complexity of the data.
Any idea?
Thanks.
Hi,
Do a Forced concatenation as two tables do not have exactly the same set of fields.
TableA:
LOAD field1,
field2,
field3,
field4
FROM SourceA;
Concatenate
TableB:
LOAD field1,
field2,
field3,
field5
FROM SourceB;