Data input tool not reading sheet name

[ShantanuDagar]

Hi,

I am facing a problem in 1 of the process with this month's datasets.

The input data tool or any other data input combination (Like directory-filter-formula-dynamic input) is not showing the right sheet name for many files.

When tool is browsed to select the file, sheet 1 is written in select a sheet (even when name is Export) and when clicked on dropdown menu, it says no records found.

The file format is .xlsx

Any help on the issue is appreciated.

Thanks

[binu_acs · Accepted solution]

@ShantanuDagar Can you take a copy of your input file and try again or create another excel file and copy the data into that and try again?

[ShantanuDagar]

@binu_acs Copying or redownloading didn't work.

But copy pasting the data in new excel sheet worked.

[binu_acs]

@ShantanuDagar I think your file, which was generated this month might have some problem