Data not picked up by directory tool

Hi, i'm exploring the use of directory tool. It seems to have picked up the excel file from specific folder however the data within the excel file isn't getting picked up by remaining workflow. The next tool tells me the field is not contained.

I think i am missing a step of selecting the tab within excel file. any help is appreciated.

Workflow

Accepted answers

cmcclellan

You should be using a Dynamic Input tool to actually open the file and read the data

All comments

afv2688

Did you type in the formula for the filter tool? That may be the problem

yxt

yes, it works when i use the typical input data method.

cmcclellan

You should be using a Dynamic Input tool to actually open the file and read the data

yxt

that worked! thanks! I have side questions if you don't mind helping me... I uploaded the workflow to the gallery, ran it and it produced 2 new sheet (addition/deletion) which was my intention. However the output file did not contain/retain my original 'data' sheet. I added a 3rd stream but still no data sheet.

original data not feeding to output.jpg

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703