Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to use some if statements in a preceding load but only the second half is working, the first half just renders null.
I have tried with and without wrapping in the top if( but always the same result. I also tried doing the two halves separately and appending the second one to the first but that didn't work either.
LOAD *,
if(
if(DirectionPre = 'L' and HomeAway = 'H', 'LR'),
if(DirectionPre = 'R' and HomeAway = 'H', 'RL')
,
if(DirectionPre = 'L' and HomeAway = 'A', 'RL',
if(DirectionPre = 'R' and HomeAway = 'A', 'LR'))
)
as Directionpre2;
Solved
LOAD *,
if(DirectionPre = 'L',
if(HomeAway = 'H', 'LR',
if(HomeAway = 'A', 'RL')),
if(DirectionPre = 'R',
if(HomeAway = 'H', 'RL',
if(HomeAway = 'A', 'LR')
)))
as Directionpre2;
Solved
LOAD *,
if(DirectionPre = 'L',
if(HomeAway = 'H', 'LR',
if(HomeAway = 'A', 'RL')),
if(DirectionPre = 'R',
if(HomeAway = 'H', 'RL',
if(HomeAway = 'A', 'LR')
)))
as Directionpre2;