Field names must be unique within table

Amba — Tue, 21 Dec 2021 17:11:18 GMT

Hello 🙂

While trying to load some data via this script:

RevenuesDiscounts:
load 'revenues' as type , revenues.amount, 'revenue' as type resident revenues;
load 'discounts' as type, discounts.discount_amount, 'discount' as type resident discounts;

Basically I'm creating a new table and loading data to it, a table that I named RevenuesDiscounts

Error: Field names must be unique within table
Error: load 'revenues' as type, revenues.amount, 'revenue' as type resident revenues

I don't really understand the error message. May anyone help?

Re: Field names must be unique within table

tresB — Fri, 25 Oct 2019 09:25:26 GMT

Two fields have same name ('type') in your load.

load

'revenues' as type ,

revenues.amount,

'revenue' as type //remove this and re-try

resident revenues;

topic Re: Field names must be unique within table in Connectivity & Data Prep

Field names must be unique within table

Re: Field names must be unique within table