Merge two rows into one

[New_Bee77]

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

[vchuprina]

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