I am an trying to verify column type of each row in excel sheet against an array having type numbers
TESTCASES:
test1:{"1","abc"} passes
test2:{"abc","abc"} also passes which should actually fail .Please let me know where it went wrong
code used ,
local!error:a!forEach( items:index(ri!data,"values"), expression:{ a!localVariables( local!rowNumber:fv!index, a!forEach( items: fv!item, expression:{ if(a!isNotNullOrEmpty(fv!item), if(typeof(cast(local!types[fv!index],fv!item))=local!types[fv!index],{},"Type does not match at Row"&local!rowNumber&" and column"& fv!index), {} ) } ) )
}
),
Discussion posts and replies are publicly visible