I want to write an if condition as below:
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...
May be create a link table:
LOAD DISTINCT FieldName,
'A' as Flag
Where Fieldname = 1;
'B' as Flag
Where Fieldname <> 1;
'C' as Flag
But I don't want to do concatenation..is there any simple solution..like in if condition itself..?
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.
Okay..i tried...Thanks for the solution..
Retrieving data ...