Merge DATs odd/even

[kinglevel]

Hey


I got stuck with this problem, i wanna merge two dats odd/evenly.

like this:

Dat 1
a
b
c
d

Dat 2

1
2
3
4

Result

a
1
b
2
c
3
d
4

cheers!

[Achim]

easiest way would be this

[kinglevel]

easiest way would be this

aah! Brilliant!
thanks

[selina]

you can skip merge2 & 3 if you use the Concatenate Cell option in merge 1.

[kinglevel]

you can skip merge2 & 3 if you use the Concatenate Cell option in merge 1.

hm ok.

btw, this method does not work with tables with multiple columns.

[selina]

if you want to merge tables with multiple columns, you can use reorder DATs to add an extra column, an eval DAT to put row numbers into that column, and then merge the 2 dats, sort by row number, and finally delete the row number column. slightly convoluted, example attached.

Selina

[kinglevel]

if you want to merge tables with multiple columns, you can use reorder DATs to add an extra column, an eval DAT to put row numbers into that column, and then merge the 2 dats, sort by row number, and finally delete the row number column. slightly convoluted, example attached.

Selina

ah! thats it, this is way better.
I didnt think of line numbers, great technique.