Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Variables_table:
Load
'$(vGAIDs)' as CodeIte
Autogenerate (1);
Store Variables_table into D:\TableCode.qvd (qvd) ;
Try this:
Variables_table:
Load
'$(vGAIDs)' as CodeIte
Autogenerate (1);
Store Variables_table into D:\TableCode.qvd (qvd) ;
Replace the above with your inline table
Please close the thread my marking the correct answer, if you have found 🙂