Discussion board where members can get started with Qlik Sense.
Can you help me? I would like to add column and its values from Table.2 to Table.1 via same ID fields, like in this example:
We are talikng about two different table , but with same ID's.
I also would like to do a crosstable on Table.1 which is working for me, but I need the second table col1. and other values as well.
If I do crosstable on table.1 the xxx.ID will appear as many as attribute masure exist. (example: ID: A116 has three different masure types in this case: 50; 4; 450 )
I would like to filter the mesured types, and its values via filtering, - which is also work for me - , if i do a crosstable with auxiliary table of attributes.
The problem is I will not know the second table col.1 and col.2 result/status.
Thank you , if you can help me!
If you are sure, that every ID in the tables are unique, you can use left join in load script (We are talking about load script right?)
That performs a simple leftjoin on the table 1.
Hope this helps.