I have created a workflow in which BOT will read the Text file and in the text file, BOT needs to perform multiple replacements. And the values for replacements, BOT will pick from the excel file.
Now, multiple replacements I can perform like: NotepadText.Replace(oldvalue,Newvalue).Replace(oldvalue,Newvalue) and so on.
Like this, I can perform multiple replacements but my requirement is: I need to perform multiple replacements where excel can have “n” number of columns and also “n” number of replacements could be performed. I want to make the solution dynamic.
I have an excel file with say 100 records and 10 columns. Now I would need to perform 10 replacements for these 100 records. The text from which I need to replace the text is in the text file and the text to which I need to replace text is in excel file. How this method will be used in that case.
For this, I would need to write 1000 rows, 10 for each record. And also the number of columns is not fixed. It can be 1 , 10 or even 100.
When we are using the for each row for excel, it will iterate through each row. Then second for each is for what purpose. I am not getting it properly.
Because when we use a loop for this, it will take value one by one and save in a variable then when it goes second time, the first value which is replaced, it would be lost.
If possible, Could you please provide a sample workflow. It will be a great help.