Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I am working on a data load.
Throughout a series of joins, etc... I come up with the following table IDATAS.
I need to create one more field in the table. I am trying to create the final table IDATAFINAL.
I tried this and no luck. Thoughts ? Thanks!
IDATAFINAL:
LOAD
Field01,
Field02,
Field03,
FIeld04,
Field03&'-'&Field04 AS Field05
Resident IDATAS;
Drop Table IDATAS;
Notes:
* IDATAS contains Field01, Field02, Field03, Field04 from other tables and joins
* Need to create Field05 (new Field)
* Final Table IDATA
Current Error Message:
Solved - once I renamed the fields I was all set:
IDATAFINAL:
LOAD
Field01 as NewField01,
Field02 as NewField02,
Field03 as NewField03,
FIeld04 as NewField04,
Field03&'-'&Field04 AS Field05
Resident IDATAS;
Drop Table IDATAS;
IS that returning into new table?
IDATAFINAL:
LOAD
Field01,
Field02,
Field03,
FIeld04
Resident IDATAS;
DROP TABLE IDATAS;
Solved - once I renamed the fields I was all set:
IDATAFINAL:
LOAD
Field01 as NewField01,
Field02 as NewField02,
Field03 as NewField03,
FIeld04 as NewField04,
Field03&'-'&Field04 AS Field05
Resident IDATAS;
Drop Table IDATAS;