Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Extract Part Price Data

hellyars
13 - Pulsar

Need help.  I extracted a 500 page price catalog using the Computer Vision tools. Now I need to get the trapped data.


Reference the image below.

 

  1. I want to extract CODE (column 2) and its associated price (column 3).  The "$" is the key to finding the CODE and dollar amount pair. 
  2. I want to extract the name of an item (if it is present).  The name of an item will always appear in the row preceding the row that contains the "$" and the name of the item will always be surrounded by "-" as in "- 3000 HS -" in the image.
  3. Ideally, I also want to pick up the second value pair that appears in the row after the "$".   This will usually be a +/- value pair, but it may be just a single +/-
  4. In a perfect world, I also want to capture all the text (the item description) at the start of the line with the "$" and all lines until the first line that starts with a REQS. 

Clear as mud, right?

 

 

Sample workflow attached with real data.

 

 

pricesheet 2022-02-28 144611.png

0 REPLIES 0
Labels
Top Solution Authors