Forum Discussion
Unpivot column results in This Table is Empty
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.
3 Replies
- Fowmy
Super User
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 🙂
Jimmy801Community Champion
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
CNENFRNLHow about testing each table before unpivoting?
if Table.IsEmpty(#"Previous Step") then ... else Table.Unpivot(#"Previous Step", ...)
