How to use Exclusion in set set analysis?

[sotann]

Hi everyone,

I've googled but I cant understand how to find exclusion values in set analysis?

I have two tables, I concatenate them in one and used a flag ('table one'/' table two') so I could find some id which only one table has but I can't understand how to write it down

[Lisa_P]

The set component should be :

{<flag={[table one]}/{[table two]}>}

You could try a table with id as dimension and this as expression/measure:
{<flag={[table one]}/{[table two]}>}only(flag)

[ChannaK]

dont do like 'table one'/' table two'

table1:

load 'Table1' as TableName

from table1

concatenate(table1)

load 'Table2' as TableName

from table2

TableName column will help you to find