Any alternate to Generic load?

[chaudhariv]

Hi,

Generic load works perfect when we have few values in rows that need to be converted into columns.

But I have column which has thousands of rows that need to be converted to columns.

Any suggestion or work around???

Currently I am using below code, but it is taking hours to complete.

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

[sunny_talwar]

Sometimes things look so straight forward, that you just don't think that they need additional commenting, but you bring a great point. I will work on it and will let you know when I have it ready. (Will most likely create a new document for it)

Best,
Sunny

[imsushantjain]

Thank you! You an expert so things might be strait forward for you. Looking forward to your doc/blog.