Merge data by ignoring the case

Database Support
#1

Hello Helical Insight,

In Helical Insight 4.0, I have connected to MongoDB using Drill. I have a nested JSON in which properties with upper and lower case should be considered the same. I need to merge the data by ignoring the case. Is this possible?

Thank You,
Netta.

#2

Hello Netta,

It is possible to ignore the case by changing the Upper case to Lower case or vice versa. For this, you can use the database functions that are available on the frontend. Refer to this link to learn more about applying database function https://www.helicalinsight.com/ad-hoc-report-module/database-functions/
Since you have nested JSON, create a view by flattening the JSON. Then, apply the Upper case function.

Thank You
From Team Helical.