Skip to main content
R
randolpha2037
January 20, 2023
Question

How to split merge columns in reconcile doc extraction?

  • January 20, 2023
  • 1 reply
  • 0 views

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.

1 reply

R
randolpha2037Author
January 20, 2023

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.

Terms & ConditionsAccessibility statement