Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i have set a variable in data load script but i cant see it in the edit mode of sheets
Table1
LOAD
Field1,
Field2
RESIDENT DATA_TABLE;
Table2
LOAD
Date
RESIDENT DATE_TABLE;
The variable looks like this
Let V_Name = IF(Date>1.3.2018,Field1,Field2);
What could be the problem ?
Try thins:
IF(Date(peek ('Date',0,'Table2'))>Date#('1.3.2018','D.M.YYYY')) then
LET V_Name = peek ('Field1',0,'Table1') ;
else
LET V_Name = peek ('Field2',0,'Table1');
end if;
You can not access the fields of resident table without using functions like peek or fieldvalue
Please post a sample app or your script so that we can advise you better