Schema update approach

[at7140]

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

[ParthaSarathy]

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.

[at7140]

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]

@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.