Data not picked up by directory tool

[yxt]

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.

[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.

[afv2688]

Sorry my bad, dunno why thought it was a normal input file.

The directory tool only returns the file types given in a specific folder. If you use the browse tool you will see all the information given about each file.

The way you set it (*.*) will return all files in this particular directory, not the file content

[cmcclellan · Accepted solution]

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.

[cmcclellan]

It really should be a different question, so you can mark this one as being solved and correct, but if you want the original data in there, you have to add it in as well.

Also, with your "block until done" tools, you only have 1 stream attached so they aren't really doing anything at all.