topic Re: How to write if condition to get all values in the script... in App Development

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

kavita25 — Wed, 26 Oct 2016 10:35:28 GMT

Hi Everyone,

I want to write an if condition as below:

For e.g

Fieldname

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

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

sunny_talwar — Wed, 26 Oct 2016 10:38:02 GMT

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;

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

kavita25 — Wed, 26 Oct 2016 10:50:49 GMT

Thanks...

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

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

sunny_talwar — Wed, 26 Oct 2016 10:53:49 GMT

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.

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

kavita25 — Wed, 26 Oct 2016 11:06:15 GMT

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