Update Datatable column name when it contain certain word?

Dear all,

I’m trying to see whether it is possible to rename a datatable column name when a certain word is found, so to synchronize the data and merge them later. Any help is greatly appreciated!! @Yoichi


Can you also share specific input sample and expected output?


1 Like

Hi @winnie_toh ,
You can use if check contains
then assign
yourDT.Columns(index).ColumnName = “New Column Name”
can you share your file and conditions

1 Like

Thank you!! This solution is just what i needed!

1 Like

cheer @winnie_toh ,
happy automation

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.