Hi all,
first of all, I'd like to mention that I'm a complete newbie. So, any advice is welcome:
I have 4 tables:
a.) BalanceSheet_LocalGaap (actual + previous period)
b.) BalanceSheet_IFRS (actual + previous period)
where I want to compare certain attributes to the previous period (via FileBaseName in script and Set Analysis).
The tables LocalGaap and IFRS have more or less the same field names. To avoid synthetic keys, I used Qualify in the second table. Unfortunately, QLIK now qualifies the table of the actual period as well as the previous period table:
BalanceSheet_LocalGaap:
Date(Date#(Right(FileBaseName(),6),'YYMMDD'),'DD.MM.YYYY') as DateBalanceSheet,
ReferenceNo,
Account,
MarketValue,
HedgeAccounting,
etc,
FROM [lib://LocalGaap*.xlsx] //*
(ooxml, embedded labels, table is [sheet1);
Qualify *;
Unqualify ReferenceNo;
BalanceSheet_IFRS:
Date(Date#(Right(FileBaseName(),6),'YYMMDD'),'DD.MM.YYYY') as DateBalanceSheet,
ReferenceNo,
Account,
MarketValue,
HedgeAccounting,
etc,
FROM [lib://IFRS*.xlsx] //*
(ooxml, embedded labels, table is [sheet1);
WORKSHEET RESULT (example Market Value:
BalanceSheet_IFRS.MarketValue
BalanceSheet_IFRS-2.MarketValue
Does anyone have any idea what I am doing wrong here? Renaming the fields makes no sense in my opinion (about 100 fields to rename)
Thank you very much for your support!
Steve