Forum Discussion

Matthiaskirsch's avatar
Matthiaskirsch
New Member
2 years ago
Solved

Text files

Dear all,   being an absolute greehorn, I would appreciate getting instruction how to use Powerquery and the associateeditor for the following problem: I have a folder with .txt- files, each consi...
Tips and Tricks
  • AlienSx's avatar
    AlienSx
    2 years ago
    let
  Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
  custom1 = Table.FromColumns(List.Transform(Quelle[Content], each Lines.FromBinary(_)),Quelle[Name])
in
  custom1
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

let

source=Folder.Files(YourPath),

custom1=Table.FromColumns(List.Transform(source[Content],each "your code to import text files"),source[Name])

in

custom1

Matthiaskirsch's avatar
Matthiaskirsch
New Member
2 years ago

So I just learned, that it is you, whom I have to thank for the working code. THANKX,

Matthias

 

Just made a mistake and replied to myself, which of course is stupid.