concatenation

Ayoub — Wed, 10 Apr 2019 08:45:32 GMT

Hey Community ,

I have a little Probleme here. First i'll show u my code .

========================================

Base_Tiers:

LOAD Code_client as Code FROM
[D:\Base_Tiers_DIM.qvd]
(qvd);
store Base_Tiers into D:\D.qvd(qvd);

DQvd:
LOAD Code as CodeFromDQvd
FROM
[D:\D.qvd]
(qvd);

TempCodeFromDQvd:

LOAD
chr(39) & Concat(CodeFromDQvd, chr(39) & ',' & chr(39), CodeFromDQvd) & chr(39) as TempCodeFromDQvd
Resident DQvd
;

LET vGAIDs = peek('TempCodeFromDQvd');

DROP TABLE TempCodeFromDQvd;

Variables_table:

LOAD * INLINE [
CodeIte,
$(vGAIDs)
];

Store Variables_table into D:\TableCode.qvd (qvd) ;

============================================

the problem is that the informations in the variable vGAIDs are like : '123','7988','1345'

and i want to store them in the TableCode.qvd, so that when i load the TableCode. Qvd

i should get my Code separatly.

Thankyou So much for your help

Re: concatenation

jyothish8807 — Wed, 10 Apr 2019 11:16:24 GMT

Try this:

Variables_table:

Load

'$(vGAIDs)' as CodeIte

Autogenerate (1);

Store Variables_table into D:\TableCode.qvd (qvd) ;

jyothish8807 — Wed, 10 Apr 2019 11:15:48 GMT

Replace the above with your inline table

jyothish8807 — Fri, 12 Apr 2019 05:31:09 GMT

Please close the thread my marking the correct answer, if you have found 🙂