Hey folks,
Following script has the issue that in won't chain the fields Changes.A from table Changes and B from table Types together. I tried working with the column identifiers (A, B) and aliases (Change and Name), both in qualified and unqualified form. Whenever I execute the script I get the error that it's unable to find the first field used in the concatenation of the Strings ([Changes.A] &'/'& as script_TestConcact).
The script works fine without the linked string, the tables are joined correctly by their common column Type (please do not advise me that I shouldn't use JOINs in Qlikview - I'm aware of it). Chaining fields from the same table works also fine.
So hopefully anyone can help me out? Thanks for your ideas in advance!
Kind regards!
The script:
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';
SET NullInterpret='';
QUALIFY A;
Changes:
LOAD A as Change,
D as Due_Date,
E as Due_Week,
G as Count_Types,
H as Type
FROM
[$(vp_FilePathIn)]
(ooxml, no labels, header is 1 lines, table is [$(vp_TableName)]);
Types:
INNER Join(Changes)
LOAD A as Type,
If(B='NV', null(), B) as Name/*,
[Changes.A] &'/'& as script_TestConcact
/*,
Changes.Change &'/'& Types.Type as script_TestConcat*/
FROM
[\\somePath\Data.xlsx] (ooxml, no labels, table is "Types", header is 1 lines);
