Need validation while uploading Excel

a!forEach(
  items: local!constructData,
  expression: if(
    length(
      where(
        and(
          local!constructData.advisorCode = fv!item.advisorCode,
          local!constructData.lineOfBusiness = fv!item.lineOfBusiness
        )
      )
    ) > 1,
    "Duplicate: " & fv!item.advisorCode & " - " & fv!item.lineOfBusiness,
    null
  )
)

tried provided code. But both entries are getting uploaded. It is not triggering the validation

Excel parse rule/plugin not populating local!constructData correctly. Share parse code for exact fix

I mean share local!constructData output to help you better.

it is inside a!foreach we will not get data

Can you share your full code?
I hope you are using file upload validation parameter to validate.

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)
)