How can I avoid $syn key in this case?

amaaiia — Thu, 02 Mar 2023 15:50:00 GMT

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.

Re: How can I avoid $syn key in this case?

BrunPierre — Thu, 02 Mar 2023 17:08:43 GMT

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;

topic Re: How can I avoid $syn key in this case? in App Development

How can I avoid $syn key in this case?

Re: How can I avoid $syn key in this case?