Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to display some data on a table where 4 different flags evaluate as true
So for example :
if Flag 1 = Y display abc, if flag 2 = Y display cde if Flag 3 = y display fgh if flag 4 = y display ijk
Is this possible with if statements? and if so how as i've tried multiple ways but can't get it to work
Thanks
Hi @Bantamfan84,
Is this what are you looking for?
MyData: LOAD Flag1, Flag2, Flag3, Flag4, If(Flag1 = 'Y', 'abc', If(Flag2 = 'Y', 'cde', If(Flag3 = 'Y', 'fgh', If(Flag4 = 'Y', 'ijk')))) AS Display INLINE [ Flag1, Flag2, Flag3, Flag4 Y,A,A,Y B,Y,C,C B,Z,Y,C Y,Y,Y,Y ];
Hi @Bantamfan84,
Is this what are you looking for?
MyData: LOAD Flag1, Flag2, Flag3, Flag4, If(Flag1 = 'Y', 'abc', If(Flag2 = 'Y', 'cde', If(Flag3 = 'Y', 'fgh', If(Flag4 = 'Y', 'ijk')))) AS Display INLINE [ Flag1, Flag2, Flag3, Flag4 Y,A,A,Y B,Y,C,C B,Z,Y,C Y,Y,Y,Y ];