Forum Discussion
Appended Queries are Showing null Values
I have 18 spreadsheets that all have the same common column "Sold To Name"
I have appended all the spreadsheets together based off the same column name being on all 18 spreadsheets. It says they are all appended. The new columns are added to the primary spreadsheet, but the all the values are saying null. When I go to filter a column, all the column items are there.
Am I doing something wrong?
Hi Anonymous ，
Try the following steps to do troubleshooting:
1. check whether the columns of the two tables you are appending queries with have the same headers,exactly same headers.Otherwise,it will appear null value in the column which doesnt exist in previous table such as below:
2.Check if the null value did exist in previous table.
3.If above cant solve your problem,could you pls show me your sample data,I will test for you.
Best Regards,
Kelly
3 Replies
Hi Anonymous ，
Try the following steps to do troubleshooting:
1. check whether the columns of the two tables you are appending queries with have the same headers,exactly same headers.Otherwise,it will appear null value in the column which doesnt exist in previous table such as below:
2.Check if the null value did exist in previous table.
3.If above cant solve your problem,could you pls show me your sample data,I will test for you.
Best Regards,
Kelly
I doubt that the spreadsheet has empty rows. Can you check each sheet for blanks in powerbi , by filtering for blank or null?
Have you scrolled to the right?
If there are spelling differences in the headers, these values would appear in different columns (which would appear right to the columns of the first table)
