Chain fields from 2 tables together

Tue, 26 Feb 2013 08:23:14 GMT

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

Re: Chain fields from 2 tables together

Wed, 27 Feb 2013 08:06:43 GMT

Good morning,

Ideas? Anyone?

Any hints appreciated!

Regards!

topic Re: Chain fields from 2 tables together in QlikView

Chain fields from 2 tables together

Re: Chain fields from 2 tables together