database functions Archives

How to Delete an Applied Database Function in Helical Insight

Once you have created a report using applied database function there might be a need to delete the applied DB function or change those values. In this blog, we will learn how we can go about doing the same. Below is the snapshot of the report which is created by applying Database function on one

business intelligence, database functions, delete database function, helical insight, open source

Share with

Database Functions for Unstructured Data

A lot of NoSQL and non-relational databases (like Mongo, Elastic Search etc) are able to store the data in the form of arrays, JSON and objects. In many cases, we would like to access this unstructured data for creating reports like bursting, flattening, finding key values etc. There are a couple of options which Helical

business intelligence, database functions, Flatten Function, helical insight, json, open source

Share with

Upper Database Function Usage in Helical Insight

In this blog, we will learn how to convert all the characters in a string to uppercase characters from text column in Helical Insight. Below you can see we are having a column in text. If we want to convert all the characters in a string to uppercase characters. Click on column. Click on more,

database, database functions, upper case database

Share with

TRIM Database Function Usage in Helical Insight

In this blog, we will learn how to remove all specified characters either from the beginning or the ending of the string from text column in Helical Insight. Below you can see we are having a column in text. If we want to remove all specified characters either from the beginning or the ending of

database, database functions, time database function, trim database function

Share with

To_Time Database Function Usage in Helical Insight

In this blog, we will learn how to convert value to TIME from text/date/dateTime/time column in Helical Insight. Below you can see we are having a column in format “HH:MM:SS”. Click on column. Click on more, a user will get two options i.e., Quick and Advanced Click on “Advanced” in this you will see a

database, database functions, time database function, to-time database