Unpivot column results in This Table is Empty

[Anonymous]

Hi all,

My source is coming from a folder with multiple excel files which have been formatted into the same headers and range. When I try to unpivot the columns (these columns are basically dates as header and value under the header), it will show as

"This table is empty"

I have manage to identify which excel files are causing the error but I can't seem to pinpoint the issue in the excel file. Excluding the files which causing the error, I mange to unpivot the columns perfectly without any issue.

Do let me know if any other information I need to provide.

Thanks. 

[CNENFRNL]

How about testing each table before unpivoting?

if Table.IsEmpty(#"Previous Step") then ... else Table.Unpivot(#"Previous Step", ...)

[Jimmy801]

Hello @Anonymous 

i just can think of that you are applying some function to every Excel-file (Read file, promote headers in the usedrange, etc) and this function causes to get a empty table of one Excel-file. Are you unpivoting the data after reading every single file or after combing all results?

BR

Jimmy

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn