Need validation while uploading Excel

Question

No warning or error message is displayed when the user uploads a file containing duplicate advisor code and Line of business.
I need validation message when I am uploading more than 1 entry with same data.
a!forEach( items: local!constructData, expression: if( count( index( fv!item[local!constructData.advisorCode], wherecontains( fv!item[local!constructData.lineOfBusiness], tostring(local!constructData) ) ) ) > 1, "Duplicate Line of business", null ) ),

shubhama926776 · Accepted Answer

a!localVariables(
  local!constructData: {
    a!map(advisorCode: "A01000", lineOfBusiness: "Life"),
    a!map(advisorCode: "A01000", lineOfBusiness: "Life"),
    a!map(advisorCode: "A02000", lineOfBusiness: "Health")
  },

  /* Create combined keys */
  local!allKeys: a!forEach(
    items: local!constructData,
    expression: fv!item.advisorCode & "|" & fv!item.lineOfBusiness
  ),

  /* Find duplicates */
  local!duplicates: a!forEach(
    items: local!constructData,
    expression: if(
      count(
        wherecontains(
          fv!item.advisorCode & "|" & fv!item.lineOfBusiness,
          local!allKeys
        )
      ) > 1,
      "Duplicate: " & fv!item.advisorCode & " - " & fv!item.lineOfBusiness,
      null
    )
  ),

  reject(fn!isnull, local!duplicates)
)

Check this sample code.

shubhama926776 · Answer

a!forEach(
items: local!constructData,
expression: if(
count(
index(
fv!item[local!constructData.advisorCode],
wherecontains(
fv!item[local!constructData.lineOfBusiness],
tostring(local!constructData)
)
)
) > 1,
"Duplicate Line of business",
null
)
),

Sign up

Login with SSO

Login to the community

Login with SSO