Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Insert row if headers of 2 file are same

videet
8 - Asteroid

I have 2 excel with same headers, I want to compare headers of both excel and combine both file.

If headers are same the add a row  contains value True(formula is in excel final) for each header 

Please see input and output(final)

 

Thanks

Videet

1 REPLY 1
messi007
15 - Aurora
15 - Aurora

@videet,

 

Please see below:

messi007_0-1618556078470.png

If headers are not the same I'll generate an error with the union tool

 

messi007_1-1618556146394.png

Hope this helps!

Regards,

Labels