Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Amba
Contributor II
Contributor II

Field names must be unique within table

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? 

Labels (1)
1 Reply
tresesco
MVP
MVP

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;