Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Append is replacing some values with null

Hi,   I am using four different excel files that have the same structure, and contains some columns which are calculations (IF, LOOKUPS etc). When I load in each of the files, and clean them (remov...
Need Help
  • Bohumil_Uhrin's avatar
    Bohumil_Uhrin
    5 years ago

    Hi Anonymous ,

    I dont think, that excel formulas could cause this problem. Are you sure, that the column names are exactly the same?

    Certainly, if you could share the files, it will be easier to solve this.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Bohumil_Uhrin , you are right, it seems like some columns started with a capital letter and some didn't. Thank you! 

Bohumil_Uhrin's avatar
Bohumil_Uhrin
Helper II
5 years ago

Anonymous Good to hear. I dont know how you solved it, however it is not recommended to change column headers "manually".

The best practice is to use normalization function (eg. proper) inside TransformColumnNames function.

Also using "trim" to get rid of unwanted spaces is not a bad idea.

 

 

#"New table"=Table.TransformColumnNames(#"Previous table",Text.Proper)
#"New table"=Table.TransformColumnNames(#"Previous table",Text.Trim)