Forum Discussion
List Transform with Extra Columns
I know I shouldn't be asking this silly question but I am stuck here.
I found one possible solution how to have better performance on getting excel files.
But after doing it, I cannot get my columns with the code I learned.
I need the [Name] Column also but doesn't know how to show.
Here is my sample function used and the code that I want to amend but don't know how.
Thank youuuu
Hi mussaenda ,
the key is NOT to write the function for the binary extraction by hand, but to use the "Expand binary"-method by clicking the arrows in the column like described here:
https://www.excelguru.ca/blog/2016/12/21/new-combine-binaries-experience/
This will automatically create a couple of queries, one of them the function itself, and another a query that is "married" to the function: All changes you make there will be reflected in the function as well. That's very convienent in my eyes and keeps the name-column.
5 Replies
Not sure if this meets your need, but you could use List.Zip to combine your List.Transform list with #"Removed Other Columns2"[Name], and get a list of lists that you can then expand.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi mussaenda ,
the key is NOT to write the function for the binary extraction by hand, but to use the "Expand binary"-method by clicking the arrows in the column like described here:
https://www.excelguru.ca/blog/2016/12/21/new-combine-binaries-experience/
This will automatically create a couple of queries, one of them the function itself, and another a query that is "married" to the function: All changes you make there will be reflected in the function as well. That's very convienent in my eyes and keeps the name-column.
Hi MFelix , thanks for recommending ImkeF !
Hi ImkeF , as always, you are a great help to this community.
I am more comfortable with Power Query than DAX but I only knew now that I can touch the Tranform File crerated when I clicked the arrow from column header.
What I always do is load everything then transform from there.
The only downside of this is that, if the formula of my custom columns are not correct and the data of my mention columns are changing, I am encoutering error and cannot trace where the error is since I can only see the sample file.
But hey, your links and tips are very helpful to newbies like me. I will do this tip from now on to all my reports with xls files and csv.
And also, it solved my question! Thank you so muchhhhhh!
