You need to sign in to do that
Don't have an account?
Carsten 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
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
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.