Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
New_Bee77
Contributor

Merge two rows into one

I wanted to add two rows data into one row

row1          row2

hmc1       hmc4

hmc2      hmc5

hmc3     hmc6

---------------------------------------

merge_row

hmc1

hmc2

hmc3

hmc4

hmc5

hmc6

Labels (2)
1 Reply
vchuprina
Specialist

Hi,

You can just concatenate rows. For this, you should load the original data, and load it again, but rename row1 as row2. See example below

Data:
LOAD * Inline[
row1, row2
hmc1, hmc4
hmc2, hmc5
hmc3, hmc6
];

Concatenate(Data)
LOAD
row2 as row1
Resident Data;

Result:

vchuprina_0-1650402940657.png

 

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").