Count totals tool (crew macro) eliminating dynamic input of the missing file

[ShantanuDagar]

Hello,

I am using a workflow with multiple input files undergoing some transformations and creating pivot tables for each in report format etc. and outputting to single file.

Thus union tool is getting used.

Also, not all files might be present for a given run. So sometimes the report would contain 7 snippets corresponding to each file, while sometimes 5.

That's why have used dynamic input tool to input the files from a folder.

But running into an issue with Count totals tool being used to total records for pivot table in each report. It basically negates the dynamic input for the absent file by returning no records and no headers which then gives error in union due to no input found.

How to solve this while not removing the count totals tool?

Thanks

[jdminton]

@ShantanuDagar could you please provide your workflow as an attachment. It is very difficult to understand your issue from the description. Sample data would help as well.