Rename field in SQL query and not in LOAD

jakobjensen — Tue, 04 Jan 2022 10:31:07 GMT

Say I have the following database table

id | gender --+------------ 1 M 2 F

I want to change the name in the SQL-query and *not* in the LOAD query i.e

LIB CONNECT TO 'database'; LOAD customer_id, gender; [my_table]: SELECT "id as customer_id","gender" FROM "public"."table";

but I get a load-error since "customer_id" is not found.

(note above is just for illustration purpose, the original query is way more complex thus the renaming has to be in the SQL-query and not the LOAD-statement)

Re: Rename field in SQL query and not in LOAD

tresB — Tue, 04 Jan 2022 10:35:53 GMT

Try correcting the quotes like:

LOAD customer_id, gender; [my_table]: SELECT "id" as "customer_id","gender" FROM "public"."table";

topic Rename field in SQL query and not in LOAD in Connectivity & Data Prep

Rename field in SQL query and not in LOAD

Re: Rename field in SQL query and not in LOAD