Adding a new field into the dataload

[jerryr125]

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:

The following error occurred:

Field names must be unique within table

[Anil_Babu_Samineni]

IS that returning into new table?

IDATAFINAL:
LOAD 

Field01,

Field02,

Field03,

FIeld04

Resident IDATAS;

DROP TABLE IDATAS;

[jerryr125 · Accepted solution]

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;