Replace with null

[stephenedberkg]

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.

[sunny_talwar]

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;