merging some rows into one

[martinqlik]

Hello community!

I have the scenario below:

ACCOUNT LEVEL_CP  ACCOUNT DESCRIPTION

104001           P11000           Commercial Bank Account   

123000           P11200           Accounts Receivable           

123003           P11200           Holdback Receivable           

How do I show this in one line like that:

ACCOUNT LEVEL_CP  ACCOUNT DESCRIPTION        LEVEL_CP1  ACCOUNTDESCRIPTION1     LEVEL_CP2    ACCOUNTDESCRIPTION2

104001      P11000      Commercial Bank Account    P11200        Accounts Receivable             P11200          Holdback Receivable

I must show this in a pivot table if is possible.

Does anyone knows how to make this up?

Thank y'all.

[Anonymous]

Something like this?

[martinqlik]

Not exactly like this, because it comes in a qvd in that way below:

ACCOUNT LEVEL_CP  ACCOUNT DESCRIPTION

104001           P11000           Commercial Bank Account  

123000           P11200           Accounts Receivable          

123003           P11200           Holdback Receivable          

Some logic must be created in the script to show these informations in just one line.

[vishsaggi]

How many rows of data your get from your QVD? You are saying technically if there are more than 10 rows of data all the 9 rows should be on right of the first row with 9*3=27 fields? Is this what you are looking for? If yes, what is the reason behind doing that way, what exactly you are trying to display here and what exactly is your requirement to show the user?

[Anonymous]

I agree with vishsaggi‌  You should think about why you would want that many columns created.

What I provided should work in a pivot table.

If you need to do it in the load script I suggest you look at the generic load.

The Generic Load

[martinqlik]

Thank you guys for answering.

What I meant to say was that I need to merge several rows into one alone.

Data comes from QVD in different rows, my client wants to classify these informations in one row because it's the correct way to analyse the context.

I have read generic load already, but not seems it will attend my purposal.

I may attach the qvw if you guys want to.

[Anonymous]

That would be helpful.

[martinqlik]

For example,

When I chosen 4015231 in the dimension filter JE_HEADER_ID, my table must show all data in one line, and not in three lines, like you can see.

[#9]

See Attached. Not Perfect.

[Anonymous]

Hi,

Have you tried using the group by function to group the data into one table.

Perhaps this could help