Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago
Solved

Trying to make additional column from source table

Hi, i am adding additional column with data source, like if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else [Connect...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

     

    = if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else Expression.Evaluate(Text.RemoveRange([Connector],0), [PostgreSQL.Database = PostgreSQL.Database])

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

 

= if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else Expression.Evaluate(Text.RemoveRange([Connector],0), [PostgreSQL.Database = PostgreSQL.Database])