topic Re: How to merge two rows into a single row in QlikView

How to merge two rows into a single row

Anonymous — Tue, 17 Oct 2017 17:41:29 GMT

I wanted to merge content from two rows into a single row. Here is an example, if the input is the below table.

Header 1	Header 2	Header 3	Header 4
I2	I1	I3	I4
I6	I7	I8	I9

The output should be as shown below

Header 1	Header 2	Header 3	Header 4
I2 I6	I1 I7	I3 I8	I4 I9

Kindly let me know how I can proceed with this.

Re: How to merge two rows into a single row

vishsaggi — Tue, 17 Oct 2017 19:53:57 GMT

Use Concat() function to merge the data. Like.

LOAD Concat(Distinct Header1, ' ') AS Header1,

Concat(Distinct Header2, ' ') AS Header2,

Concat(Distinct Header3, ' ') AS Header3,

Concat(Distinct Header4, ' ') AS Header4

FROM yoursourcetable;

Re: How to merge two rows into a single row

Anil_Babu_Samineni — Wed, 18 Oct 2017 00:57:57 GMT

Red this

Concat - script function ‒ QlikView

Re: How to merge two rows into a single row

MarcoWedel — Thu, 19 Oct 2017 22:37:28 GMT

Hi,

another solution might be:

table1:
LOAD Previous(Header1)&' '&Header1 as Header1,
    Previous(Header2)&' '&Header2 as Header2,
    Previous(Header3)&' '&Header3 as Header3,
    Previous(Header4)&' '&Header4 as Header4
INLINE [
    Header1, Header2, Header3, Header4
    I1, I2, I3, I4
    I5, I6, I7, I8
    I9, I10, I11, I12
    I13, I14, I15, I16
    I17, I18, I19, I20
    I21, I22, I23, I24
    I25, I26, I27, I28
    I29, I30, I31, I32
]
Where Even(RecNo());

hope this helps

regards

Marco