topic Join tables or create a second data model? in QlikView

Join tables or create a second data model?

Malle — Sat, 16 Nov 2024 21:25:41 GMT

Hey!

I am having trouble to decide what to do with my data set.

I have a "customer cases"-table that is linked with ~10 dimension tables and now I have a different dataset called "Benchmark cases" which has nearly the same (but a little less) info but refers to the same dimension tables and 1 different one.

How can I add the benchmark to the existing model without having all sorts of Sync keys?

I thought I can join the tables and try adding a field "Benchmark" (0 or 1) or create a new data model that is not linked at all with the other data.

Is this a good way to achieve this or is there another possibility?

Thanks in advance! 🙂

Re: Join tables or create a second data model?

Mathias — Tue, 12 Feb 2019 10:10:57 GMT

I think the best option is to concatenate those 2 tables with an extra field "benchmark" (0 or 1)

Re: Join tables or create a second data model?

juliensaintmaxent3113 — Tue, 12 Feb 2019 10:44:11 GMT

Hello,

yes, use the function concatenate and add field like 'Table1' as Table in the first table and 'table2' as table in the second.

When you want to use measure on the first table, make set analysis with the good value.

Bye