Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if there no values in database i want to replace it by 0
Replace(ID,'','0') as ID
i am using this formula in script but i did't getting the answer.
May be you can do something like this:
Table1:
LOAD ID as ID1,
Sales
FROM Source1;
Table2:
LOAD ID,
LockPeriod
FROM Source2;
Concatenate (Table2)
LOAD ID1 as ID,
0 as LockPeriod
Resident Table1
Where not Exists(ID, ID1);
FinalTable:
LOAD ID1 as ID
Sales
Resident Table1;
DROP Table Table1;