Combining columns

Question

Hi,This is probably a really easy fix but I have columns in my table called Shift Date, Shift Start timeI want to combine these as a custom column and then convert to a date time, but for the life of me I cannot get it to work. They are both text at the moment (sisense wont let me put them in as datetime at the start).I am using excel sheet for now and here is an example snippet of the data:I have tried using SELECT[Shift Date],[Shift Start Time],[Shift Date] || ' - ' || [Shift Start T...

HamzaJ · Accepted Answer

Hey danielrabinovit ,|| is not a valid sisense sql expression. To concatenate you can use either concat() or +. In your example it would be something likeconcat(concat([Shift Date],' - ' ),[Shift Start Time]) AS combined_columnThis 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...