Forum Discussion
deadshot1680
Oct 26, 2021Copper Contributor
help me to grep list of coloumn numbers in csv file
https://stackoverflow.com/questions/69729027/i-need-to-extract-datafor-a-set-of-particular-coloumn-number-of-a-csv-file
1 Reply
Sort By
- SergeiBaklanDiamond Contributor
That's job for Power Query
1) query the table with column numbers, in editor add prefix "Column". Let say that is table Columns which has only one column Number
2) query csv file and add step Table.SelectColumns(Source, Columns[Number])
3) land result into Excel sheet