Select sheet from excel based on condition

Question

I have a 2 excel workbook one workbook has some record and the second one has multiple sheets. Based on some conditions I have to select the sheet from the second workbook. Example below

2nd workbook has 2 sheets -> Apple and mango

1st workbook has records ->

FruitApplemango

Condition :

So 1st row which has Apple So I have to open the apple sheet and do a join and if it has mango I have to open sheet name mango and do a join.

grazitti_sapna · Answer

Hi @Sshasnk , I have prepared a mock workflow, can you please have a look and let us know if it works for you?

What I have done is I read all the sheets from another source and filtered it as per requirement.

Thanks.

DynamicInput-GS.yxzp

atcodedog05 · Answer

Hi @Emil_Kos ,

I think dynamic tool is a better choice. Since we need to read multiple sheets.

atcodedog05 · Answer

Great and Interesting approaches @Emil_Kos  😀👍