Basiclly I want to Concatenate two Excelfiles that has transactions for two different years. But Concatenate results in two different tables instead of one.
I've figured out that it is due to the fact that I Qualify all fields but the date-field. If I dont Qualify all fields the Excel-files Concatenate as intended...but I end up with other un-intended effects i.e. fields loose tablename "table.field", I also get un-intended keys to other tables...)
QUALIFY *;
UNQUALIFY datum_YearMonth;
personal:
LOAD
left(Period,4) & '-' & mid(Period,5,2) as datum_YearMonth
,Antal
,Apris
,Belopp
FROM
$(ExcelRelativeOriginalFolder)Personal\Personal.xlsx
(ooxml, embedded labels, table is Sheet1);
CONCATENATE (personal) LOAD
left(Period,4) & '-' & mid(Period,5,2) as datum_YearMonth
,Antal
,Apris
,Belopp
FROM
$(ExcelRelativeOriginalFolder)Personal\Personal.xlsx
(ooxml, embedded labels, table is Sheet1);
