Loop for saving individuals qvds in different folders

[Zaga_69]

Hi,

I have multiple QVDs in a folder in the server. I would like to save each QVD in an specific folder in the server. 

The image below shows you that I have multiple QVDs in the folder called facts. I want to take each QVD from there and saved in a different server folder. A loop might be helpful here. Any idea?

Thanks!!!

[Zaga_69]

Hi,

I tried this, however it does not work properly, since each QVD in Table_List is being saved in each GBU_Path. What I need is to save each QVD in its corresponding GBU_Path. Any idea? Thanks!

LOAD *
Inline [
Table_List; GBU_Path
HET_GMD_FACTS.qvd; Stream_2500_QStorage\30_Datamart\
HPM_GMD_FACTS.qvd; Stream_2400_QStorage\30_Datamart\
](Delimiter is ';');

For Each vGBU in FieldValueList('Table_List')
For Each vGBU_Path in FieldValueList('GBU_Path')
$vGBU:
LOAD *
FROM [lib://Stream_0600_QStorage\30_Datamart\$(vGBU)] (qvd);
STORE $vGBU INTO [lib://$(vGBU_Path)\$(vGBU)] (qvd);
DROP TABLE $vGBU;
NEXT;
NEXT;