Hex 0A in table

v-qiuyu-msft 

It seems to be caused by transformating a list of Excel files into a single file via the folder function from Get Data. The null value seems to be replaced by the 0A symbol. 

First transformation in the Transform file group :

let
Source = Excel.Workbook(Parameter4, null, true),
#"Contract Data_Sheet" = Source{[Item="Contract Data",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Contract Data_Sheet", [PromoteAllScalars=true]),
#"Cols" = Table.ColumnNames ( #"Promoted Headers"),
#"Replace" = Table.ReplaceErrorValues ( #"Promoted Headers" , List.Transform ( #"Cols" , each {_ , "!"}))
in
Replace

Second transformation to combine them all :

let
Source = Folder.Files("X:\"),
#"Filtered Rows" = Table.SelectRows(Source, each not Text.Contains([Name], "DQ")),
#"Filtered Hidden Files1" = Table.SelectRows(#"Filtered Rows", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (4)", each #"Transform File (4)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (4)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (4)", Table.ColumnNames(#"Transform File (4)"(#"Sample File (4)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Contract ID Product ID", type any}, {"Custo. ID", type any}, {"Nom client", type any}, {"Contract ID", Int64.Type}, {"Client Final", type any}, {"Product ID", type text}, {"Description", type any}, {"Date Debut DPS", type any}, {"Date Fin DPS", type any}, {"AC 2019 each 1000", type any}, {"Dealer Cost 2019 each 1000", type any}, {"Quantité", type any}, {"Pays", type any}, {"Commercial", type any}, {"CONCA", type any}, {"Account Manager", type text}, {"Correct AM", type any}, {"Pieces", type any}, {"Rev", type any}, {"Contract Rev", type any}, {"List price 2020", type any}, {"List Price 2020 Increase", type any}, {"Suggested Increase by Pricing", type number}, {" Pricing Recommendation", type text}, {"Adjusted Cost Actual Increase (%)", type number}, {"Adjusted Cost Actual Increase (amount)", type any}, {"2020 Adjusted Cost (NEW) each 1000", type any}, {"Difference Adjusted Cost Increase (%) (Actual- Suggested)", type number}, {"Increase %", type any}, {"New Rev AC", type any}, {"New Contract Rev", type any}, {"Contract Increase", type any}, {"ACTION by AM", type text}, {"AM Comments", type text}, {"Comment by Regional Manager", type any}, {"Pricing member", type any}, {"Contract Status", type any}, {"Item Status", type any}, {"Renewal Priority", type text}, {"LHF", type text}, {"Classification", type text}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type", each [Contract ID Product ID] <> null and [Contract ID Product ID] <> ""),
#"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows1",{{"Custo. ID", type text}, {"Contract ID", type text}, {"Date Fin DPS", type date}, {"Date Debut DPS", type date}})
in
#"Changed Type1"