About marcpaige

marcpaige · 03-02-2023

I think I found a bug in the toChar() function but want to make sure here first.When using the format "HH:mm", toChar() does not emit 24 hour time format. Instead it emits "hh:mm" format. Also, if I try to give it "hh:mm a" as a format string, it com...

marcpaige · 02-27-2023

I am trying to create a new derived view using Incorta SQL. I am not trying to do anything tricky that I am aware of. I have checked the syntax for the query against Spark SQL for the CASE statement and it doesn't look out of order. Here is the query...

marcpaige · 01-23-2023

Additional string functions:left(string,int) to return the left x characters of a string.right(string,int) to return the right x characters of a string.

marcpaige · 12-29-2022

I often have to deal with data that are imported from dialers. These data come in a string duration format (e.g. 00:01:12:04 for 1 hour, 12 minutes, and 4 seconds.) I would like to have similar functions to the date/timestamp extraction functions (se...

marcpaige · 10-26-2022

I am trying to do a seemingly simple thing. I thought I could use a result-set approach but it did not work.So, here is the task: group averages of numbers based on a category. An aggregate insight does that well. The problem is I want to put in a fo...

marcpaige · 03-01-2023

Thanks, Joe. the field I am using on the left is an Incorta Date data type. The right side is an attempt to get the current date. I had hoped that I could use $currentDate but the Incorta SQL complains that the $currentDate is:Unknown column $current...

marcpaige · 03-01-2023

I was able to correct all of my syntax errors and convert to Incorta functions and it runs. On a separate note, I am trying to compare a date to the current date in the WHERE clause. I have tried getDate(), curdate(), current_date(), $currentDate, an...

marcpaige · 01-23-2023

Hi @JoeM,No, I am saying this is basic string functionality that has never been in the built-in functions.substring(string, int, int) can be similar to right(string, int) but you have to know the length of the overall string and then know the proper ...

marcpaige · 01-23-2023

btw, Substring() is not the same.

marcpaige · 11-04-2022

Thanks again, Zach. This makes perfect sense.

User Statistics

User Activity

the undiscovered country

Trouble with CASE in Incorta SQL view

Additional String Functions

Extended Duration functions

What is a simple Excel reference is hard in Incorta?

Re: Trouble with CASE in Incorta SQL view

Re: Trouble with CASE in Incorta SQL view

Re: Additional String Functions

Re: Additional String Functions

Re: What is a simple Excel reference is hard in Incorta?