MergeMultiple rows into columns

[venkatg6759]

Hello Everyone,

                          I have below table

Desc	Val
Errors	1
Category	Loan
Sub Category	Loan Sold
Label	Record Count

I Need to separate and make it show like this

Errors   Category   Sub Category      Label

1           Loan          Loan Sold            Record Count

Can anyone help me how to do this.

Thanks in advance,

Venkata

[sunny_talwar]

Try this:

Table:

Generic

LOAD 1 as Field,

  *

Inline [

Desc, Val

Errors, 1

Category, Loan

Sub Category, Loan Sold

Label, Record Count

];

DROP Field Field;

[Clever_Anjos]

Is your table

1. A source (excel, sql, etc)
2. An object?

[venkatg6759]

It's not excel.It's coming from SQL.these are just 2 columns in that table.

[#5]

Hi Venkat,

What is the DB you are using like Oracle, MySQL etc..

Thanks,
Sreeman

[Colin-Albert]

Generic Load can fix your data as suggested by Sunny T sunindia‌

This post has more details The Generic Load

[johnw]

Yet another example of a generic load. This is from one of my live applications, with a little unneeded complexity removed, hopefully without breaking it. Same idea as Colin_Albert‌'s link to hic's generic load, where the columns are all combined into one table instead of left as separate tables, just a slightly different approach to building that final table.

// Creates one Generic.* table per Facility Event LCID/Class
[Generic]:
GENERIC
LOAD
[Order Item]
,[Facility Event LCID/Class]
,[Manufacturing Result]
FROM ManufacturingInstructions.qvd (QVD)
;

// Build new flat table with distinct order items.
// This is faster than a load distinct.
[Flat]:
LOAD text(fieldvalue('Order Item',recno())) as [Order Item]
AUTOGENERATE fieldvaluecount('Order Item')
; 
// For each table that still exists
LET i = 0;
DO WHILE i < nooftables()
    LET vTable = tablename($(i));
    // If it's one of our Generic.* tables
    IF  subfield(vTable,'.',1)='Generic' THEN
        // Add the field to our flat table.
        LEFT JOIN ([Flat])
        LOAD *
        RESIDENT [$(vTable)]
        ORDER BY [Order Item]
        ; 
        // And delete the Generic.* table
        DROP TABLE [$(vTable)]
        ; 
    ELSE
        // Not a Generic.* table. Skip past it.
        LET i = i + 1;
    ENDIF
LOOP

[venkatg6759]

Will try this .But Generic Load worked for me .Later I merged column tables to main table by join.Thank you John

[venkatg6759]

This was helpful colin .Thanks

[johnw]

If the generic load serves your needs, you're done. I wouldn't introduce complicated scripting like I show above to combine the fields into one table. I needed it so that I could store the result as a QVD. If you don't have that or another compelling reason to combine the fields, just leave them like the generic load builds them. I really should have mentioned that in my original post, but I wasn't thinking it through, just grabbing an example.