topic Adding a new field into the dataload in Connectivity & Data Prep

Adding a new field into the dataload

jerryr125 — Thu, 23 Jan 2020 19:56:00 GMT

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 — Fri, 24 Jan 2020 11:14:34 GMT

IS that returning into new table?

IDATAFINAL:
LOAD

Field01,

Field02,

Field03,

FIeld04

Resident IDATAS;

DROP TABLE IDATAS;

jerryr125 — Sun, 26 Jan 2020 08:28:30 GMT

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;