Can't SELECT renamed field, error field not found.

[wuming79]

Hi,

IP	time
1.1.1.1	1529445600
2.2.2.2	1529670000
3.3.3.3	1529770010

Using Data Load Editor as below, I will get Circular reference error. I found out that it is due to the field time.

LOAD IP,

  time,

[Table1]:

SELECT `IP`,

  time

FROM testDB.Table1;

I then tried to rename the "time" field to below but after I load data, I will see error such as "Field 'IP' not found.

LOAD IP,

  time AS newTime,

[Table1]:

SELECT `IP',

  newTime

FROM testDB.Table1;

I tried to add change IP to 'IP' but when I create a bar chart with 'IP', my chart shows only the text 'IP' instead of all the 3 IPs from the table.

How do I do a proper rename during Data Loading time without changing my other fields?

[jonathandienst]

You need the "as" alias in the SELECT, not in the preceding load:

[Table1]:

LOAD IP,

    newTime;

SELECT IP

  time as newTime

FROM testDB.Table1;

[wuming79]

Hi,

Using the syntax:

[Table1]:

LOAD IP,

    newTime;

SELECT IP

  time as newTime

FROM testDB.Table1;

qliksense reported

The following error occurred:

Field 'newTime' not found

The error occurred here:

?

[jonathandienst]

Missing comma after SELECT IP

[Table1]:

LOAD IP,

    newTime;

SELECT IP,        //<< missing comma

  time as newTime

FROM testDB.Table1;