Grooper 21.00.0082 is available as of 12-12-2023! Check the  Downloads Discussion  for the release notes and to get the latest version.
Grooper 23.00.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0018 is available as of 04-15-2024! Check the  Downloads Discussion  for the release notes and to get the latest version.
Options

get the values from different directions for same data field

mounikapotlamounikapotla Posts: 31 ✭
in The Astronauts (Q&A)
Hi Everyone,
we have a form type with different templates and we are extracting the data from documents using a key-value pair.
The issue is sometimes the value comes after the key and in some cases at the top of the key.
We tried both vertical and horizontal direction logic. but it's not giving good results.
Example:
1.Name: John
2.John
  Name
Here Name is a Key
John is value
Please help.

Thanks,
Mounika Potla.
Tagged:

Answers

  • Options
    tgarnetttgarnett Posts: 76 ✭✭✭
    Hi Mounika,

    You should be able to accommodate both formats. Here I've enabled Horizontal and Vertical layouts, and set the Vertical Direction to "Reverse" since the Key will be below the Value.


  • Options
    mounikapotlamounikapotla Posts: 31 ✭
    Hi @tgarnett,
    I have tried as you suggested but still getting same issue.
    At horizontal direction, the value was there in the right side of the key but while extracting the data it is fetching the above key.



    Thanks,
    Mounika Potla.
  • Options
    tgarnetttgarnett Posts: 76 ✭✭✭
    Is it possible to make your Value extractor more specific? If the value can't be more specific, you might be able to filter out bad results in the "Result Filter" property of your Value data format, like specifying a maximum font size.

    You could also try separating the vertical and horizontal into separate extractors. Here the Horizontal Key would look for "Name:" while Vertical looks for "Name" without the colon. So if a colon exists after the key, the extractor will not look above for the value.

     
  • Options
    GrooperGuruGrooperGuru Posts: 481 admin
    So there is logic built into Key Value Pairs that determines which value gets associated to a key. If you have a single Key Value Pair that uses both horizontal and vertical options, it will attempt both and ultimately choose to keep the value that is geometrically closet to the key. In your screenshot above, that means that "project summary detail" is actually closer than "1-4H". If your key value pair also enables flow layout, it will prefer the result of the flow layout before falling back to the geometric layouts. If you cannot make the value more specific as a way to prevent false positives, then you may need to create multiple kay value pairs, but have each key value pair only execute one layout style. Then you can reference both key value pairs and use the "Extractor Order"  sorting method to determine which layout style should win.
    Matt Harrison
    Product Manager
    mharrison@bisok.com
Sign In or Register to comment.