Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Am trying to get the ID numbers where Date field should be empty and result field should be Pass. I am trying to do this within Data Manager.
if([Date]='Null' and [Result]='Pass','Null', ID)
Getting error near the ' ) ' . Can someone help me out.
Thanks,
SAK
Hi Santosh,
Unless 'null' is the string in the cells in the column, have you tried "IF(ISNULL(Date) AND Maxstring(Result) = 'Pass', NULL(), ID)"? or otherwise alternatives around the functions being called for in the "if" statement.
Kr,
Cheenu
if( Len(Trim([Date]))=0 and [Result]='Pass',Null(), ID)
Thanks for the response Cheenu. Unfortunately, its not working.
Thanks for the response @Sasidhar Parupudi. Its not working though.
Adding to this, the same 'if' condition was working in direct data load. If I try to do the same in qvd, I am unable to do.
Hi
try below by removing Null() May be it works
like below
=if( Len(Trim([Date]))=0 and [Result]='Pass', ID)
try this :
load ID,Date(Date) as Date,Result,
if(len(Trim((Date)))=0 and Result = 'Pass' ,ID) as empty_date_ID
;
LOAD * INLINE [
ID, Date, Result
1, 1/1/2017, Pass
2, 1/2/2018, Fail
3, 1/3/2017, Pass
4, , Pass
5, 3/4/2018, Fail
6, , Pass
];
Hi,
Then the problem is latter in your script. Usually, error description doesn't refer to the actual line that it has happened
Hi Santhosh,
Try the below expression:
IF(ISNULL([Date]) AND [Result] = 'Pass', 'NULL', [ID])
Thank you!
Best Regards,
Sumit K