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);
