Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this table,
and i want to create a new column DATE_03 when if ([TYPE]="A";[DATE_01];[DATE_02])
This would result table
May be this:
LOAD TYPE,
DATE_01,
DATE_02,
If(TYPE = 'A', DATE_01, DATE_02) as DATE_03
FROM source;