function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Carsten BONOMOCarsten BONOMO 

Automation Studio Script

Hello everyone,

I'm running some tests in Marketing Cloud's Automation Studio. I would like to import, filter and then update the filtered data.

I managed to import by FTP, filtered with a Data Filter but can't manage to update the filtered data.

I've been trying to use an Automation Studio Script to achieve this. According to https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/index.htm it seems like AMPscript is the best language for my issue (I'm not very familiar with scripting languages).

I tried out UpdateData (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/updatedata.htm) and UpdateDE (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/updatede.htm) without any success. 

This is my interpretation of how these functions work : UpdateData('TestC1',1,'Class of Service','Standard','Eligibility',true) where
- TestC1 is the Data Extension I want to update
- 1 the number of columns used in the determination of the correct row to update
- Class of Service the name of the column used in the determination of the correct row to update
- Standard the value in the column used in the determination of the correct row to update
- Eligiblity the name of the column containing the data to be updated
- true the value of the data to insert

But after inserting this script in Automation Studio the Data Extension isn't changed one bit.

Thanks a lot in advance for any help,
Carsten
Carsten BONOMOCarsten BONOMO
One extra bit of explanation :
What I'm trying to achieve with this script is setting the value of Eligibiliy to true for each record with a Class of Service equal to Standard.