concatenation

[Ayoub]

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 

[jyothish8807 · Accepted solution]

Try this:

Variables_table:

Load 

'$(vGAIDs)' as CodeIte

Autogenerate (1);

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

[jyothish8807]

Replace the above with your inline table

[jyothish8807]

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