How to concatenate a predefined List Variable based on condition in excel value

ranjitNK

New Member
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:
1638895147229.png
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 1638895323395.png
It should be like this below. Like wise next cell will be stored with another grp of data concatenated.

1638895354036.png

But looping is not working for some reason, missing something. Please guide.
 
Top