Forum Discussion
Power Query get columns
From UI, you may follow these steps,
1. To keep only needed columns, select the columns: 'Content', 'Name', 'Date modified', right-click and choose Remove Other Columns
2. Import file content
- Click the Add Column tab
- Choose Custom Column
- Name it: Data
- Use this formula:
Csv.Document([Content], [Delimiter=";"])3. Promote headers by clicking Use First Row as Headers on the top ribbon
4. Expand nested table
In the main query, click the expand icon beside the Data column
Select the columns you want to import (from your CSV conten)
Hello Brinki,
do you like removing all the columns except for these 2 columns ? if that so, simply click on shift or ctrl cant remember which one, and select with your mouse on the column name and date modified.
then right click on one of these 2 columns, --> remove other columns .
let me know if this is what you want. if not ,feel free to reply to my respond.