Field names must be unique within table

[Amba]

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? 

[tresB]

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;