Generic tables null values

[#1]

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

[sunny_talwar]

May be do it in a final resident load

NullAsValue *;

SET NullValue = '*';

FinalCombinedGenericTable:

NoConcatenate

LOAD *

Resident CombinedGenericTable;

DROP Table CombinedGenericTable;