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

Shubham Aware · Answer

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
 )
) Filter nulls and show in validation: reject(fn!isnull, {above code})

Shubham Aware · 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.