Excluding Data Source if no values other than header row

Question

Working on a flow that is using several excel files as the sources.   Depending on results,  there may or may not be results in file #4.   If there isn't all I have are the column headers.    This is causing the date column to be changed to Double data type,  which when joined with other items is causing complications further down the flow.

Trying to figure out the best way to bypass file #4 if there is no data.

Any help would be appreciated.

Thanks.

danilang · Answer

Hi @DodgerFH

Add a Select tool after Input 4 and force all the field types to their valid values.

Dan

Raj · Answer

@DodgerFH 
one way of doing this is adding a dummy data to the output so the data type remains the same and then after union you can remove the dummy data
hope this helps.

apathetichell · Answer

use a count records tool. use a filter to filter if the count is or is not zero.