Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generic tables null values

Hi All,

I tried to use below script to convert rows to column. However this script is generating lot of null values in result table.

Is there anyways I could replace all null values with symbol '*' while performing left join

Set vListOfTables = ;

   For vTableNo = 0 to NoOfTables()

      Let vTableName = TableName($(vTableNo)) ;

      If Subfield(vTableName,'.',1)='GenericLabel' Then

         Let vListOfTables = vListOfTables & If(Len(vListOfTables)>0,',') & Chr(39) & vTableName & Chr(39) ;

      End If

   Next vTableNo

   CombinedGenericTable:

   Load distinct Key From GenericDB;

   For each vTableName in $(vListOfTables)

      Left Join (CombinedGenericTable) Load * Resident [$(vTableName)];

      Drop Table [$(vTableName)];

   Next vTableName

Regards,

Sravanthi

The Generic Load

1 Reply

May be do it in a final resident load

NullAsValue *;

SET NullValue = '*';

FinalCombinedGenericTable:

NoConcatenate

LOAD *

Resident CombinedGenericTable;

DROP Table CombinedGenericTable;