I want to find a specific word in column A and replace it.
I already tried it with this description:
If you are looking to do the operation in datatable, first of all convert the datatable to string by using “Output Datatable” activity.
Then add a “Replace” activity with input(output of ‘Output Datatable’ activity), Pattern(“2018”) and Replacement(“2019”).
Use ‘Generate Data Table’ activity with input(output of ‘Replace’ activity) and pass it’s output datatable to write an excel file.
And when I start the application, I get the whole file in column A (I mean every column is written in column A, separated with a comma.