Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Contatenate local varaibles in QVD file

Guys,

here is my code:

Sub Map (vTableName, vTableId, vFullFileName, vPath)

    Let vMapingTable = '$(vPath)Mapping.qvd';

    IF (NOT isNull(qvdCreateTime('$(vMapingTable)'))) THEN

        Map_Table:

        LOAD * From $(vMapingTable);

        Concatenate (Map_Table)

        LOAD * INLINE [

        FullFileName, TableName, TableId

        $(vFullFileName), $(vResTable), $(vTableId)

        ];

    ELSE

        Map_Table:

        LOAD * INLINE [

        FullFileName, TableName, TableId

        $(vFullFileName), $(vResTable), $(vTableId)

        ];

    ENDIF

    Store Map_Table into $(vMapingTable);

    Drop Map_Table;

End Sub

This function is supposed to be called many times to store some values in a QVD file.

Here i check if the file exists and if it does then i load that QVD file and then trying to concatenate the current values to it and then store it in QVD file.

In case the QVD file does not exist then I just store the current variables in the QVD file.

It is not working.

First pass goes well i.e. the "ELSE" part of code and it stores the data in QVD file.

During subsequent passes i.e. "IF" part of code is creating problem...during this pass when the control comes to "Store ...." statement then debugger stops running and I see in log that "Map_Table << INLB85" kind of statements there.

Can you please help me what is going wrong here?

0 Replies