This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi @Faridininho, I'm not sure which database you used for the query. You
can use GROUP_CONCAT if using MySQL or BigQuery, and STRING_AGG is
applied to SQL Server, Azure SQL Database, and Azure Synapse Analytics.
Both concatenates the values of string...
Hello @Devi_V,You can create a new explore file and include it in the
model. Or you can create the explore in model itself. However, you have
to provide reference of views in explore or model files. (use include
parameter)Step 1: To keep things simpl...
Hi @laburakab, If you want to show the date format in the SQL select
convert(varchar(max), DateColumn, 13), format(DateColumn, 'dd-MMM-yyyy')
from MyTable