Create QVD with Qlik Tables

LDenivelle — Sat, 16 Nov 2024 04:35:32 GMT

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

Re: Create QVD with Qlik Tables

Gysbert_Wassenaar — Thu, 31 Jan 2019 17:09:33 GMT

Try: where TableDest = '$(TableNameDest)'

Re: Create QVD with Qlik Tables

LDenivelle — Thu, 31 Jan 2019 17:14:38 GMT

haha

how to lose time for 2 quotes 😄

Thanks a lot !

topic Re: Create QVD with Qlik Tables in QlikView

Create QVD with Qlik Tables

Re: Create QVD with Qlik Tables

Re: Create QVD with Qlik Tables