topic Re: How to associate column in different table through writing script in data load editor in QlikView

How to associate column in different table through writing script in data load editor

Fion_c — Thu, 13 Aug 2020 05:40:32 GMT

I have three tables

table 1:

user id, product , company

table 2:

sales id, sales, name

table 3:

Id, age, address

user id from table 1, sales id from table 2 and id from table 3 are the same things.

How can I associate them without renaming the column title.

Re: How to associate column in different table through writing script in data load editor

Almen — Thu, 13 Aug 2020 06:13:02 GMT

You can duplicate the field if you want to keep the original.

table 1:

user id as ID$,

user id,

product ,

company

table 2:

sales id as ID$,

sales id,

sales,

name

table 3:

Id as ID$,

Id,

age,

address

Re: How to associate column in different table through writing script in data load editor

Fion_c — Thu, 13 Aug 2020 10:09:30 GMT

Thank you for your reply.

However, it cannot match other information.
For example, when I put ID$, name and age together , they can't be matched.

Re: How to associate column in different table through writing script in data load editor

Almen — Thu, 13 Aug 2020 13:09:31 GMT

Not sure if I follow. You've stated all three ID fields are the same thing. Therefore I assume you can link them together. If one of those fields has an ID missing, there can't be a match with that table obviously.

Re: How to associate column in different table through writing script in data load editor

Brett_Bleess — Tue, 25 Aug 2020 18:59:56 GMT

I believe you can simply create an alias of each of those where that alias is the same name across all three tables, that should automatically link the tables for you, but given your post above, I am not sure what is what you want to do now, but that is what you indicated on the initial post... Need further clarification otherwise.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Alias.htm

Regards,
Brett