How to write if condition to get all values in the script...

[kavita25]

Hi Everyone,

I want to write an if condition as below:

For e.g

Fieldname

1

2

3

4

5

if(Fieldname = '1','A',

if(Fieldname <> '1','B',

if(Fieldname = 'ALL','C',

)

ALL is whole value in the field.

Please help me with this issue...

Regards,

Kavita

[sunny_talwar · Accepted solution]

May be create a link table:

LinkTable:

LOAD DISTINCT FieldName,

          'A' as Flag

Resident Fact

Where Fieldname = 1;

Concatenate (LinkTable)

LOAD DISTINCT FieldName,

          'B' as Flag

Resident Fact

Where Fieldname <> 1;

Concatenate (LinkTable)

LOAD DISTINCT FieldName,

          'C' as Flag

Resident Fact;

[kavita25]

Thanks...

But I don't want to do concatenation..is there any simple solution..like in if condition itself..?

[sunny_talwar]

AFAIK, if won't be able to handle it. Why are you hesitant to use concatenation here? your data model should not be impacted too much because you won't expand your Fact table, it will only be a link table.

[kavita25]

Okay..i tried...Thanks for the solution..