
Contributor
2022-04-19
01:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
351 Views
1 Reply

Specialist
2022-04-19
05:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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").
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
324 Views
