Dim Issue

[azmeerrehan]

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

[sunny_talwar · Accepted solution]

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;