Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
please chech\k below image and code.
LOAD * Inline[
TableName
CustomerLegar
DimAccount
DimCustomer
DimEmployee
DimProduct
DimProductCategory
];
for i = 1 to FieldValueCount('TableName')
let Vtable = FieldValue('TableName',i);
select * from $(Vtable);
store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);
Next
may be try below
for i = 1 to FieldValueCount('TableName')
let Vtable = FieldValue('TableName','$(i)');
select * from $(Vtable);
store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);
Next
EDIT:
I think we are missing the extension of the file we are going to load first..
add a space
LOAD * Inline[
LOAD * Inline [
Try following code.
You forgot to add LOAD before SQL
for i = 1 to FieldValueCount('TableName')
let Vtable = FieldValue('TableName','$(i)');
$(vTable):
LOAD
*
;
SQL select * from $(vTable)
;
store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd;
DROP TABLE $(vTable);
NEXT