Update Datatable column name when it contain certain word?

[winnie_toh]

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

[Yoichi]

Hi,

Can you also share specific input sample and expected output?

Regards,

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

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
regards,

[winnie_toh]

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

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

cheer @winnie_toh ,
happy automation