Customer experience | Sales, Customer Insights,...

Updating entire column of data in a table according to rule

(0) Share

Report

Posted on by Anya

I have a table where the entries in the Owner column as all set to the same value, a lookup field. I would like to attempt to edit this entire column and try to set the owner by using the value from another column. So far, I've done this by exporting to excel, changing the values and importing it.

Is there a better way to go about this? Where do I start?

Thank you.

All responses (2)

Answers (0)

Suggested answer

SamiraM 571 on at

Like (0)

Report

RE: Updating entire column of data in a table according to rule

Hi Anya,

For Bulk data update or upload best is to use www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-365 SSIS.

You also have options to add conditions and do data cleansing work with SSIS.

Regards

Samira
Suggested answer

Manoj Mane 1,012 on at

Like (0)

Report

RE: Updating entire column of data in a table according to rule

Hi Anya,

You can refer below tool to update the data. It is a good handy tool.

Bulk Data Updater for Microsoft Dataverse and the Power Platform

Thanks,
Manoj Mane.

Please mark this as VERIFIED if it helps.