
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can't SELECT renamed field, error field not found.
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?
- Tags:
- rename field


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Missing comma after SELECT IP
[Table1]:
LOAD IP,
newTime;
SELECT IP, //<< missing comma
time as newTime
FROM testDB.Table1;
