I am preparing a workflow using computer vision tools to read numerous purchase card statements from PDF files. I have successfully read each file using PDF to Text. My workflow results in a record for each transaction. However, I have not determined how to flag/identify a transaction with a credit amount (as shown in screenshot).
PDF to Text configuration:
Text Extraction Options - Read Text Content Only checked with Risk Score and Output selection checked
Output Options - Alteryx Table
Looking for suggestion on how to isolate these credit values. Thanks for the help.
WG
Solved! Go to Solution.
Do you feel comfortable using RegEx? I'd probably use it to identify all the spaces and determine the difference based on how many spaces there are before the last value!