Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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! 🙂
I think the best option is to concatenate those 2 tables with an extra field "benchmark" (0 or 1)
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