I am working through RDP, on my client's server in Austria, and I can't send anything from it.
I am using my personal computer for communications here. Sorry..
My sales data is from a datawarehouse and has around 150 columns
but from them I use around 40, my table is named Sales
My budget data is from excel file and i have I
1. Item Number
8. Budget value
All the Fieldnames from the excel file, are present in the Sales table,
so i was wondering if Concat is possible, but Im not sure if it's not going to disrupt my other Data..
off course, that's why the link table.
LOAD distinct COMMONFIELD1, COMMONFIELD2, ... COMMONFIELD_N from BUDGETTABLE;
LOAD distinct COMMONFIELD1, COMMONFIELD2, ... COMMONFIELD_N from SALESTABLE;
If you don't won't a "synthetic" Link Table, then you could use autonumber()...