topic How to concatenate two field while reading it from ini in QlikView

How to concatenate two field while reading it from ini

Tue, 11 May 2010 07:48:13 GMT

Hi All,

Can some one please help me to me to concatenate two field while reading it from ini.

In the attached document I have managed to read "PS01" from STR=PS01 which is there in the ini. Now what i want is read "2009" from Year=2009 which is there in the ini. Concatenate both and show it as PS012009 in mypath which is there in the document.

I know it is very simple. But not getting any idea how to do this.

How to concatenate two field while reading it from ini

Tue, 11 May 2010 10:06:30 GMT


MyInifile:
LOAD
 MID(@1, INDEX(@1, '=') + 1) AS DataIn
FROM
  (txt, codepage is 1252, no labels, delimiter is '\t', msq)
WHERE
 LEFT(@1, 4) = 'STR=' OR
 LEFT(@1, 5) = 'Year='
;
AsAField:
LOAD FieldValue('DataIn', 1) & FieldValue('DataIn', 2) AS MyPath RESIDENT MyInifile;
AsAVariable:
LET varMyPath = FieldValue('DataIn', 1) & FieldValue('DataIn', 2);

How to concatenate two field while reading it from ini

Tue, 11 May 2010 10:53:08 GMT

Hi Martin,

It was a excellent work. Full credits to you. But I am not able to understand how your script works. I had gone through tutorial also but I am not able understand how it works. Will be thankful to you if you can explain me the script line by line.