Excel import case sensitivity topic

0
Hi Team, I'm importing an excel and in that excel I'm using some fields those master data is maintained in application and I'm mapping imported data for those fields with master data but the entries got skipped if it's not match with case. Like I have master data in title case and in excel data can be in any case. SO how can I ignore this case sensitivity while importing?
asked
1 answers
0

Hello Himanshu,

You can import your excel data into helper entity and from there you can crate microflow and using toLowerCase or toHigherCase  function you can handle your issue.

answered