Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a preceding load wherein I am creating Calculated Fields to be used in the same Load statement.
I want to Keep the field name Date. so can I drop Date after renaming Date_1 into Date?
Load*,
Rename Date_1 into Date;
Drop Field Date;
Load*,
if (Date_2 ='X', 'Flag', Date) as Date_1 ;
I would suggest changing the order of Rename and Drop as well
DROP Field Date;
Rename Field Date_1 to Date;
Hi,
Push the Rename and Drop after the LOAD statement.
Load *,
if (Date_2 ='X', 'Flag', Date) as Date_1 ;
Load * From [File];
Rename Field Date_1 to Date;
Drop Field Date;
Sorry.. It should be..
Drop Field Date_1;
I would suggest changing the order of Rename and Drop as well
DROP Field Date;
Rename Field Date_1 to Date;