topic Re: Join many tables in the same sheet in Excel file in Alteryx Designer Desktop Discussions

Join many tables in the same sheet in Excel file

Gaby — Wed, 10 Oct 2018 16:29:58 GMT

Greetings,

I am completely new in Alteryx and would like to join many tables present in the same Excel Sheet.

Basically, I have the data like this:

Product Price Country1 Product Price Country2 Country3

P1 55 1 P98 58 2 3

P5 30 2 P3 20 0 1

Each table has more than 500 records and approximately 10 columns. Under the country column, we have the units for that country.

The aim if to transform all this in one table and one file with a column country having the country and a column units having the units.

I join a copy of the type of file.

Any idea of how this can be done?

Thank you very much in advance.

Re: Join many tables in the same sheet in Excel file

TylerNa — Wed, 10 Oct 2018 20:41:13 GMT

The attached workflow should get you on your way!

Re: Join many tables in the same sheet in Excel file

Gaby — Thu, 11 Oct 2018 10:34:42 GMT

Thank you very much for your help, but I need something that can be automated. I mean I wont have to manually select all the columns. I have more than 10 tables per sheet with 10 columns each. I am trying not to go to 100 table to tick the right one.

Re: Join many tables in the same sheet in Excel file

alexey_nikityuk — Thu, 11 Oct 2018 10:51:47 GMT

Gaby, i think prior solution makes sense as 1) there is one button how you can select all columns to be included and 2) yes, you would need to manually exclude those empty columns but from your description it seems like there are no more than 10-15 of those columns, so i think you may try to use what Tyler proposed

Re: Join many tables in the same sheet in Excel file

Gaby — Thu, 11 Oct 2018 11:17:29 GMT

Thank you! You were right! I tried and it does not take time. pretty straight forward!

Re: Join many tables in the same sheet in Excel file

Gaby — Thu, 11 Oct 2018 11:18:13 GMT

Thank you very much! I t works perfectly!

Re: Join many tables in the same sheet in Excel file

TylerNa — Mon, 15 Oct 2018 17:49:45 GMT

@Gaby if you do end up needing a dynamic way of removing null columns I found this really helpful macro that @Joe_Mako developed that does just that!

Delete Null Rows or Columns Macro

Re: Join many tables in the same sheet in Excel file

Gaby — Tue, 16 Oct 2018 14:25:32 GMT

Thank you! @TylerNa