How to split merge columns in reconcile doc extraction?

randolph over 1 year ago

I have a CDT SOA_SUMMARY which is the parent of CDT SOA_ITEMS.
In reconciliation the three columns (Bill Ref No., Bill Date, SOA Number) are merge into one.

I cannot select or draw manually to configure the column and my workaround is to manually clean the data.

Can you please help me to split the array of string using a script task and assign the values to designated column? It should be in a loop to iterate each row.

Discussion posts and replies are publicly visible

0 randolph over 1 year ago

a!localVariables(
  local!extractedInfo: "10754250 11/26/2022 SOA-0000778701",
  local!split: split(local!extractedInfo, " "),
  local!patient: ri!soaCDT.soaItems,
  
  a!forEach(
    items: local!patient,
    expression: 
    split(fn!index(fv!item,"billRefNo",null), " ") & " " &
    fn!index(fv!item,"billDate",null) & " " &
    fn!index(fv!item,"soaNumber",null)
  ),
  
  /*a!map(*/
  /*bilRef: fv!index[1],*/
  /*bilDate: fv!index[1],*/
  /*soa: fv!index[1]*/
  /*)  */
)

I tried the code above but I do not know yet how to assign it or update the value in the CDT.