Take cell contents from 2 diferente excel files and merge it in one new table

Ask a question
1

hi, i was wondering if parabola con do this?

take two values from 2 diferente excel files and merge it in one new table?

can this be done?

thank you for your cooperation

diana

2

Hi @diana_carolina_barre

Check out the “Combine tables” step. This will allow you to merge data from 2 different Excel files and join them on a matching value.

If you want to combine the tables but there are no shared values, use the “Insert Text Column” step after each Excel file to create a column with the value of Yes.

You can then use the “Combine tables” step to merge on a shared Yes value.

1 Like