Additional Semi Colon in IDP Key-Value Extraction in Process Variable

Question

Hi All,
I am using the Advanced IDP to extract Key-Value pairs from a PDF. Even though the key - values are present in a 2 columns table, I decided to use Key-Value extraction instead of table extraction as each key occurs only once. I can see the extracted values properly in the IDP object, in the output of IDP in the process, but whenever I am assigning the values to individual variables or CDT inside a process, lot of additional semi colons are getting appended along with repetition of the main value. I could see a pattern - if the key is available in the 3rd row of the table, then 2 semi colons are getting appended before the value, if the key is in 4th row, then 3 semi colons and so on. Example: ; ; abcde; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; abcde; ; ; ;
Any idea?

kapils024874 · Answer

Hi [mention:5de21e12b051416491e52689b6529572:e9ed411860ed4f2ba0265705b8793d05] ,

You can remove the extra semicolons and also eliminate the duplicate values.
I've attached a sample code for your reference.

a!flatten(
  a!distinct(
    reject(
      fn!isnull,
      fn!split(ri!extractedString, ";")
    )
  )
)

Additionally, you can review the mapping by using Appian functions like stripWith and replace to clean the inputs before assignment or by checking trim and check for null/empty values.

Sign up

Login with SSO

Login to the community

Login with SSO