Updating ingested profiles organizational unit through a workflow

[mnorberg]

I'm trying to set the organizational unit of each ingested profile inside of a workflow. I want the organizational unit to be updated to the same value for each profile. So the order of operations is: 

• ingest csv file with profile information
• update each profile record to have the same organizational unit
• update profiles database with the newly ingested profiles.

Any help would be greatly appreciated. 

[DavidKangni · Accepted solution]

Hi,

• Add an enrichment with the Org unit name
• Use a reconciliation to Org unit table on the name

Then you should be able to use the result in an update data activity

Thanks

David

[mnorberg]

Hi david thank you for your answer. Do you mind expanding on what would happen in each step?

[Sukrity_Wadhwa]

Hi @ DavidKangni, Can you help @mnorberg with their request? Thanks!

[DavidKangni]

Hi

it was already expanded

• Add an enrichment with the Org unit name --> means in your enrichment you define your recipients org unit by providing the same name as in your org unit table
• Use a reconciliation to Org unit table on the name --> means you use the org unit from the enrichment in a reconciliation with to the org unit table.

Hope that helps.

Thanks,

David