Forum Discussion
Extract List to new Column
Just leave code part. I think Extract values part will be very easy for you (it will generated required code automatically)
click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
Yes the only column I'm interested in the Choices Column and to get the data extracted, there is requirement to look at the customer specifically , that code you are looking for specific values, how do you make it generic to just create the new column and data?
Can you open one list and post here the screenshot and then you can describe what output you want...
Just leave code part. I think Extract values part will be very easy for you (it will generated required code automatically)
click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
Ok sure..
1. Extract the values from the list field, which could be anything, e.g. Apple, Pear, Carrot
2. Create a new colum with those values so it looks like
That is what I had done...You need to insert this statement in your code where you need to replace #"Added Custom" with previous step.
To do this, right click on last step of your query - Insert step after (now in formula bar, it would show your previous step which you should copy) and paste the below one into Formula bar and replace #"Added Custom" with your previous step
= Table.TransformColumns(#"Added Custom", {"Choices", each Text.Combine(List.Transform(_, Text.From), "#(lf)"), type text})Now, if you are not able to do so, then click the doubled edge arrow and Extract values.
Choose custom and then select Concatenate using special characters - Insert Special Characters - Select Line Feed - OK
Sorry you lost me there, can you post the full code?
thats the one! Sorry we got there in the end! Many thanks