Below is my usecase:
1- I have one Main folder which has multiple excel/csv files: I have created main loop for that to read files
2- Each file has multiple columns with Yes/No values stored: I have created also inner loop for read each row in file
3- I have created List Variables with predefined data stored index wise as shown below:
4- Created Loop to read cell range wise and checking values Yes/No. If the data says Yes, then take value from List Variable and concatenate to a final variable, then need to use set cell command to place tht final value
It should be like this below. Like wise next cell will be stored with another grp of data concatenated.
But looping is not working for some reason, missing something. Please guide.
1- I have one Main folder which has multiple excel/csv files: I have created main loop for that to read files
2- Each file has multiple columns with Yes/No values stored: I have created also inner loop for read each row in file
3- I have created List Variables with predefined data stored index wise as shown below:
4- Created Loop to read cell range wise and checking values Yes/No. If the data says Yes, then take value from List Variable and concatenate to a final variable, then need to use set cell command to place tht final value
It should be like this below. Like wise next cell will be stored with another grp of data concatenated.
But looping is not working for some reason, missing something. Please guide.