topic Re: Merge two Dimensions to Larger table in QlikView

Merge two Dimensions to Larger table

data_guru_001 — Sat, 16 Nov 2024 04:00:23 GMT

Hello,

Is it possible in Qlikview to take two different dimension fields, from two different tables, and merge them into one table with repeated values?

I have attached a screenshot of what I am trying to do.

Thank you!

Re: Merge two Dimensions to Larger table

Vegar — Sat, 30 Mar 2019 05:12:37 GMT

Yes you can do that with an full join. The following script will give you the desired output.

Table:
Load WK as Product
From Source;

JOIN (Table)
Load Color
From Source;

Re: Merge two Dimensions to Larger table

data_guru_001 — Mon, 01 Apr 2019 19:15:22 GMT

Thank you!!!