Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;