Convert Pdf/Text data as columns and rows in excel

[geeklarokcmie]

Hello Experts,

I have a chunk of data in PDF/text format and would want to output it as columns and rows in an excel.

Input: Please find the attached txt/pdf file

Expected Output:

rule name

Left Criteria

Column

Op

Value

Logical

Right Criteria

Column

Op

Value

Logical

Left Match Group Tolerance

Right Match Group Tolerance

Left Item

Additional Info. (L)

Op

Left Item

Additional Info. (L)

Tolerance

Exception Status

Combo Rule

Desc3=2002 Eff Dt=1

.=1

Book Flag

=

1

AND

>1

Bank Flag

=

2

AND

effectiveDate

Effective Date

YYYYMMDD

=

Effective Date

YYYYMMDD

1 Days

No

Desc3=2002 Eff Dt=1

BICode 1

=

206

Reference 3

=

2002

AI 206

.=1

Flag

=

1

AND

.=1

Flag

=

2

AND

effectiveDate

Effective Date

YYYYMMDD

=

Effective Date

YYYYMMDD

1 Days

No

AI 206

AICode

=

206

Reference 3

=

2002

[cjaneczko]

You can do it with the Intelligence Suite or the PDF Input tool and Predictive tools. 

https://community.alteryx.com/t5/Community-Gallery/PDF-Input/ta-p/887038

[geeklarokcmie]

I can't use either of the tools you mentioned. Is there any other ways to utilize the txt format and add it as rows and columns?

[cjaneczko]

PDF input with Predictive tools doesn't require an additional license. You can download the Predictive Tools from your account page and then download the PDF Input tool from the gallery. 

[geeklarokcmie]

Below is the error I'm running into:

[cjaneczko]

Did you install the predictive tools and R?  

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/PDF-Input-tool-Error-Message/m...