Hi, I'm trying to execute a MAQL command to delete...
# gd-beginners
t
Hi, I'm trying to execute a MAQL command to delete some sales using MAQL DML EXECUTE, AND I'M ONLY GETTING THIS ERROR. 'The request could not be understood by the server due to malformed syntax.' I'm trying through the cloud, the command is like this. EXECUTE DELETE FROM {dataset.tf_vendas} WHERE {attr.tf_vendas.idnotafiscal} IN (1)
image.png
j
Hi Tomas, Please refer to our documentation below: https://help.gooddata.com/classic/en/data-integration/data-preparation-and-distributi[…]ditional-data-load-reference/deleting-records-from-datasets/ The correct syntax looks for example as this:
Copy code
DELETE FROM {attr.event.eventid} WHERE {eventdate.date.yyyymmdd} = "2017-10-06"
m
Hi Tomas, we are wondering if you have the chance to check the last update of my colleague Julius. Please, let us know if you need further assistance.