topic Re: Can't SELECT renamed field, error field not found. in App Development

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

wuming79 — Mon, 22 Oct 2018 04:51:35 GMT

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?

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

jonathandienst — Mon, 22 Oct 2018 05:24:49 GMT

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;

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

wuming79 — Mon, 22 Oct 2018 06:37:12 GMT

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:

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

jonathandienst — Mon, 22 Oct 2018 12:05:39 GMT

Missing comma after SELECT IP

[Table1]:

LOAD IP,

newTime;

SELECT IP, //<< missing comma

time as newTime

FROM testDB.Table1;