Excel Merger

Question

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)

Ex2: (Excel 2)

Expected Output:

Thanks,
Harshavardhana

aleksandar_a · Answer

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.

harsha3 · Answer

Thanks so much, it is working!
Any way to add a null row on the top, like below

Thanks

Forum Discussion

Excel Merger

2 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system