Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Clean up of Table pulled from pdf

Highlighted
Alteryx Partner

I could use some help.  I took a pdf file and converted it to excel so I could format the following table.  I need to be able to clean this up so I can remove columns and data which is not relevant.  I started down the path of using a CReW macro to get rid of empty fields and then filter and sample but I cannot seem to get this to where I need it.  I would love any help I can get on this.  Much appreciated.

 

I am trying to get this workflow to look something like my end result.

 

Thank you!

 

 

Highlighted
Pulsar

I think this is roughly what you want.

 

DavidP_0-1581728622033.png

 

Labels