Excel Merger

Designing Pipelines
1

Hi,

Whether is there any way to merge two Excel data into one using the Snaplogic?

Like A,B, C and D,E, F are headers belonging to two different excel Ex1 and Ex2.

And I require a combined Excel concatenated side-ways like A,B, C,D, E,F

Screenshots below:

Ex1: (Excel 1)

image

Ex2: (Excel 2)

image

Expected Output:

image

Thanks,
Harshavardhana

2

Hi @Harsha3,

You can try by using the Join Snap with Join Type set to Merge.
[Join Snap Documentation]

Let me know if this helps you.

BR,
Aleksandar.

1 Like
3

Thanks so much, it is working!

Any way to add a null row on the top, like below

image

Thanks