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.
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.
Thanks for the response Cheenu. Unfortunately, its not working.
if( Len(Trim([Date]))=0 and [Result]='Pass',Null(), ID)
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.
Then the problem is latter in your script. Usually, error description doesn't refer to the actual line that it has happened
try below by removing Null() May be it works
=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
Try the below expression:
IF(ISNULL([Date]) AND [Result] = 'Pass', 'NULL', [ID])
Retrieving data ...