Tabulate multiple tables from a text file

Question

Hello,

I would like to tabulate a text file which consists of multiple tables.

However, I need only the tables in the output file(excel or csv) and remove all the rows between the tables.

I have attached a sample image of the file.

Is there a way I can do this in Alteryx?

Thank you

SampleImage.PNG

Pankhudri20 · Answer

Thank you!

I will work on it using the proposed workflow.

AkimasaKajitani · Answer

Hi @Pankhudri20

The workflow to make your request happen is not simple. It requires multiple tools.

The rows that you required are started by "|" or "-", so you can use Filter tool.

After that you can separate each table by Filter tools and format the tables by using Text to Columns tool and so on.

If you may use the RegEx tool, the workflow will be simple. But It takes a little getting used to.

Please refer attached file.

separate_table_sample_AK.yxmd