Dynamic selection of an input data sheet within a excel file

Question

Dear all,

Is it possible to have a dynamic selection on a sheet from a specific excel file. Meaning each month a new sheet will be added to an existing excel file. And the workflow would need to take the new sheet and not the original one...

Thanks!

Nicolaas

binu_acs · Answer

@Nicolaas_Vercruyse That is possible, if your dynamic sheet name doesn’t follow any naming patter then save your original excel sheet names in a separate file and import in your workflow using input tool,  compare with the latest input file sheet names using the join tool, then only process the new sheet information, at the end of the workflow make sure you are including the new sheet name in sheet name file, which was already saved.