Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Expression Error the csv document parameter "column's is invalid

im facing the below error regarding this query 

 

let
Source = Csv.Document(File.Contents("\\10.40.3.246\Share Risk\Middle Office\Daily\Limits Monitoring\Limit Monitor check\Daily Limits Check\MM & FX\Template\CL-FX-limit-check.csv"),[Delimiter=",", Columns=13, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Key Figure Report", type text}, {"", type text}, {"_1", type text}, {"_2", type text}, {"_3", type text}, {"_4", type text}, {"_5", type text}, {"_6", type text}, {"_7", type text}, {"_8", type text}, {"_9", type text}, {"_10", type text}, {"_11", type text}}),
#"Promoted Headers1" = Table.PromoteHeaders(#"Changed Type1", [PromoteAllScalars=true]),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers1",{{"Parent", type text}, {"Abs Nominal USD", Int64.Type}, {"Deal Nominal Amount", type number}, {"Counterparty", type text}, {"Continuation Number", Int64.Type}, {"FX Rate", type number}, {"Opening Date", type date}, {"Value Date", type date}, {"Expiry/Maturity Date", type date}, {"Currency", type text}, {"Instrument Group", type text}, {"Instrument", type text}, {"Transaction State", type text}})
in
#"Changed Type2"

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

    try to remove ", QuoteStyle=QuoteStyle.None" out ftom the first string

    do not hesitate to give a kudo to useful posts and mark solutions as solution
    Linkedin