Meet other GoodData developers. Search our knowledge base. Attend live events.

GoodData

```Hi, I'm new to GoodData lol

I would like to create a metric where I would only remove the first character from the product code and unify it with the product description + unify the respective products


I created one but apparently it's not working

SELECT CONCAT(SUBSTRING({product_code}, 2, 10), ' ', {product_description}) unified AS```


This does not look like <https://www.gooddata.com/docs/cloud/create-metrics/maql/|MAQL>, the language which GoodData uses. Could you please try and utilize our documentation to create the metric you need. Please note that this could also depend on how your datasets are connected in your data model.

Hi Vinicius, GoodData MAQL currently does not allow you to perform string operations. It is rather used for various aggregation, filtering and calculations.

If you need to perform string operations, you can either do it in your database before connecting it to GoodData or in a <https://www.gooddata.com/docs/cloud/model-data/create-logical-data-model/create-sql-datasets/|SQL dataset> inside your logical data model by using SQL functions supported by your database.