Forum Discussion
Source File Columns I Don't Want In My Data Model
Hi Anonymous ,
click on the first step of your query with your mouse and do the selection.
This will automatically insert a step for you.
Hi
The other workaround within PowerBI is, In PowerQuery Editor do the following steps.
1. Do the unpivot transformation to get all the groups into one column
2. Split using delimiter then regroup using first & last value as per your exiting group logic
3. Pivot it back.
Thanks
Venkata Nalla
Hi Anonymous ,
as the first step before all other transformations:
- Check the column you want to keep
- Righclick the mouse
- Click: Remove other columns
This will keep your column names clean and managable.
thank you, but how do i put that in context? I already applied many steps to transform my data (with the old structure). Should i apply that as an additional step?
thank you,
Atanas
Hi Anonymous ,
click on the first step of your query with your mouse and do the selection.
This will automatically insert a step for you.