Multi Sheet Data Display Issue

[sslattery17]

The workflow appears to bring in the data but its only displaying the first sheet and nulls on remaining.  All sheets have same columns.

Any suggestions? 

[alexnajm]

Can you show us the configuration of your Dynamic Input?

Have you checked out this for your baseline? The Ultimate Input Data Flowchart

[sslattery17]

@alexnajm the issue is not bringing the spreadsheet in; its a single spreadhsheet with multiple tabs (sheets).  The issue is seeing all the data; its only showing data for the first 160 + rows; the remaining data are showing null....

Each sheet is same expect for number of rows; so have more data rows than others but columns are same name same number and same order.

[alexnajm]

I understand, but without seeing more of the configuration I am just having to shoot in the dark. If you could send the file and workflow, that's the best avenue - otherwise exposing configs will help us.

[OTrieger]

@sslattery17 

There are more than 20,000 rows, why don't you add a Filter tool that remove any row where Property is null.

This will remove all the empty rows, and then you can check if all the data is there or not

[sslattery17]

@alexnajm @OTrieger I have added screen shot and spreadsheet.   I added filter to remove null rows and columns.  

[alexnajm]

@sslattery17 it works fine for me... why are you thinking it is not working? Can you check your output log to see that the files are different? I converted to .xlsx but .xls should work too

In your Dynamic Input tool, you can turn on "Output File Name as Field" to show where each row comes from

[sslattery17]

@alexnajm @OTrieger Thank you both for your time.  I have resolved this issue.  I had to delete workflow file and rebuild it.  I believe it was corrupted.