Data Association

[louise119]

I have a question about data association.
If I associate two tables A and B with item x for example, is item x the combined item x' of table A and B items?

I'd like to use item x in table A even if I combined the item x from table A and table B using association.

[hic]

I assume that you by "item" mean field or column?

If so, then yes. The field x in Qlik Sense will contain the values of field x from both the tables.

Should you want to have a field that contains only the values of one table, but still have the association, you can create this in the script:

A:
Load ...,
x as 'A.x',
x
From A;

B:
Load ...,
x as 'B.x',
x
From B;

[louise119]

Thank you so much!

You mean that I should create a script like you wrote above? By adding a new section to the load editor?

[hic]

I would edit the existing load statements for table A and B. Just add one field, and leave the other fields untouched.

[louise119]

Should I unlock the auto-generated script?
When I unlock the auto-generated script, I get a message which said "If you unlock this script, you can't use data manager any more".

Can't you do the same thing thing in Data Manager?