Solved
Combining columns
Hi, This is probably a really easy fix but I have columns in my table called Shift Date, Shift Start time I want to combine these as a custom column and then convert to a date time, but for the l...
Hey danielrabinovit ,
|| is not a valid sisense sql expression. To concatenate you can use either concat() or +. In your example it would be something like
concat(concat([Shift Date],' - ' ),[Shift Start Time]) AS combined_column
This combines those 2 fields. However it does not create a regular datetime-field. To do so you need to use todatetime() to convert it so that Sisense will recognize it as a datetime-field and you can use it as such in a dashboard. Otherwise it treat it as a text-field. More on how to convert can be found below:
https://docs.sisense.com/main/SisenseLinux/date-and-time-functions.htm
Hamza
