Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Input Data from Word document (.docx)

Magne
7 - Meteor

Hi,

 

I have many monthly financial reports in MS Word that is build up on the same structure (same headings, tables etc.). I would like to import those reports into Alteryx in order to structured and analyse the data in Alteryx and presenting later in Power BI. 

 

A good solution might be a tool that read the word document and input one row for each paragraph, including some paragraph information like style (e.g. Heading 1, Heading 2, Normal, Punctuation etc.). Where there are tables in the document; several fields should be added and separated in Field 1, Field 2... in order to extract and analyse the content of each table. 

 

Are there any solutions like this in Alteryx today, or any good workarounds? Or is it planned to be added in the close future?

10 REPLIES 10
bertal34
9 - Comet

@RogerS Thank you for the macro.  Does it work for multiple files?  What changes might need to be made?  Thanks!

Labels