Adding Flag in a table

[Lionel_Maximus]

Hello,

I have two FACT tables and they contain  several common fields i want to concatenate both of them but using Flags so the result won't be affected on the same selection.....Can anyone tell me how to do that???

Regards

[Vegar · Accepted solution]

You can use SET analysis to limit your calculations to one  data set.

FACT:
LOAD 
*,
'Fact1' as _factSource
FROM
fact1DataSource;

Concatenate (FACT)
LOAD 
*,
'Fact2' as _factSource
FROM
fact2DataSource;

In your expressions you may use expressions like I've done below for a Fact2-calculation of the Amount field

=SUM( {<_factSource = {'Fact2'}>} Amount)

[Lionel_Maximus]

Thank You 🙂