Generic tables null values

Wed, 02 Nov 2016 17:17:19 GMT

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

Re: Generic tables null values

sunny_talwar — Wed, 02 Nov 2016 17:25:22 GMT

May be do it in a final resident load

NullAsValue *;

SET NullValue = '*';

FinalCombinedGenericTable:

NoConcatenate

LOAD *

Resident CombinedGenericTable;

DROP Table CombinedGenericTable;