Create QVD with Qlik Tables

[LDenivelle]

Hi

I have a table containing all the information to create QVD (see below).

TableDest = concatenation of "Table" and "SousTable". Contains the final name for my QVD.

Code = name of my first column. Contains all the Code (id)

Libellé = name of my second column. Contains all the Libellé

For example, I want to create table perimetre_perimetre (first row of "TableDest"). The final Result would be :

I started to do this :

TableauClean:
 NoConcatenate
 load
    *,
    Table&'_'&SousTable as TableDest
    
Resident CalculTables
where not isnull(Code);
DROP Table CalculTables;

FOR i = 0 to NoOfRows('TableauClean')-1
        
    LET TableNameDest = peek('TableDest', i, 'TableauClean');
   
'$(TableNameDest)':
    NoConcatenate LOAD 
    Code,
    Libellé
    
    Resident TableauClean
    where TableDest = $(TableNameDest) //doesn't work !
    ;
    
//store $(TableNameDest) into $(vPathQVD_Dev)\$(TableNameDest).qvd;
//CALL Recapitulatif('$(TableNameDest)');
//drop Tables $(TableNameDest);
NEXT

Everything works except at the end when I want to specify which row I want to load for the table :

where TableDest = $(TableNameDest) //doesn't work !

 If I do it manualy like this :

where TableDest = 'perimetre_perimetre' //it works !

Maybe there is another way to create all the tables and generate QVD. Let me know !

Regards

[Gysbert_Wassenaar · Accepted solution]

Try: where TableDest = '$(TableNameDest)'

[LDenivelle]

haha

how to lose time for 2 quotes 😄

Thanks a lot !