casting issue
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),
{}
)
}
)
)
}
),
