Schema update approach

Forum|Forum|11 months ago
February 14, 2025
1 reply
673 views

Hi All ,

I have below problem to be solved ,

we have schema of content manage that have around 1000 entries stored , out of which i want to update 32 entries with new values , i am receiving this new data from client in CSV format , task is to update only this 32 only and other rows should be same or untouched , how we can implement this.

Thanks

Best answer by ParthaSarathy

@at7140 , if you have some unique key for these 32 records, lets say Primary key (@id), then have a split activity before update data activity and provide condition as,

@id is included in 1,2,3,4,...,31,32

So only these 32 records will get qualified out of your 1000 entries and you can update those 32 records.

ParthaSarathy

Community Advisor

Hi @at7140 ,

While creating a import workflow, in Update data activity configure only this 32 attributes in it. So that only these 32 attributes only get updated on each run.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

A

at7140Author

Level 3

Hi @parthasarathy

adding more info , we need to setup workflow for that as it is 1 time setup and 32 are different data Rows in schema with n number of fields in each rows , and all 32 rows with their fields should be update with new value from CSV file. Let me know if you need more info.

ParthaSarathy

Accepted solution

Community Advisor

@at7140 , if you have some unique key for these 32 records, lets say Primary key (@id), then have a split activity before update data activity and provide condition as,

@id is included in 1,2,3,4,...,31,32

So only these 32 records will get qualified out of your 1000 entries and you can update those 32 records.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded