Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Is there any other to keep < or > in Script part as these are not wroking.
for ex:
if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2)) as amt_F
the above column amt_F have 0 rows, when use the same if statement in front end side and I am getting values.
-Priya
Can you share the script for the table where you are doing this?
You can simplify your expression to this
RangeMax(amt_1, amt_2) as amt_F
But don't think that will resolve your 0 row issue
added
it gives me values but there are 3 scenarios
if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2,if( amt_1 =amt2 ,amt_1))) as amt_F
This seems to be working
Table:
LOAD Amt1,
Amt2,
Alt(Amt1, Amt2) as AmtF1,
RangeMax(Amt1, Amt2) as AmtF2
FROM
[..\..\Downloads\Dat sample.xlsx]
(ooxml, embedded labels, table is Sheet1);
This should still work
RangeMax(amt_1, amt_2) as amt_F
if( amt_1 > amt2 ,amt_1, amt_2) as amt_F
will work
Note : check field Name is it amt2 or amt_2
Your data will not help. Please provide proper data.
Regards
In 3rd scenario
if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2,amt_1) )as amt_F
Note : check field Name is it amt2 or amt_2
Regards,
names are fine, I just typed we can correct, take only content pls.