Exclude data in load editor or using Set Analysis based on complex condition

piotrama — Wed, 07 Feb 2018 14:26:02 GMT

Hi,

Suppose we have a table like the one below. I would like to exclude from the whole model dimension which in period = 0 has value < 10. Is there an elegant way to achive this in Load Editor in one Load or in formulas using Set Analysis (without changing anything in Load Editor)?

test:

Load * Inline [

dimension,period,value

a,0,8

b,0,12

c,0,13

a,1,15

b,1,20

c,1,25

];

I managed to do this but I'm wondering if there is a better, clever way do do this. My answer:

test:

Load * Inline [

dimension,period,value

a,0,8

b,0,12

c,0,13

a,1,15

b,1,20

c,1,25

];

// add flag which dimension should be excluded

Left Join(test)

Load distinct

dimension,

'true' as dimension_exclude

Resident test

Where period = 0 AND value < 10;

test_stage2:

Load

dimension,

period,

value

Resident test where dimension_exclude <> 'true';

drop table test;

topic Exclude data in load editor or using Set Analysis based on complex condition in App Development

Exclude data in load editor or using Set Analysis based on complex condition