Dim Issue

azmeerrehan — Mon, 10 Jul 2017 13:30:40 GMT

Attached please find the sample Excel and QVW fle. I have a DIm with values A,B,C,D AND E. I want to create a Flag with the three values:

'Only 'E''

'No 'E''

'All Values'

I am able to get 'Only E' and 'No E' but cant get the one with All Values.

How can I accomplish that flag with 3 values

Re: Dim Issue

sunny_talwar — Mon, 10 Jul 2017 13:39:42 GMT

Try this approach

Table:

LOAD Dim

FROM

[Sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

LinkTable:

LOAD Distinct Dim,

'No E' as Dim_Flag

Resident Table

Where Dim <> 'E';

Concatenate(LinkTable)

LOAD Distinct Dim,

'Only E' as Dim_Flag

Resident Table

Where Dim = 'E';

Concatenate(LinkTable)

LOAD Distinct Dim,

'All Values' as Dim_Flag

Resident Table;