Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

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