Forum Discussion
Choose columns from list
Howdy. I've got monthly data that I receive across 2000 zones, of which I only need a few hundred. I have a list of the ones I need and I'm trying to use table.removecolumns with the list as a refer...
Hi Anonymous ,
Please make sure the type of the list is in text format in the Power Query Editor instead of Desktop model.
Or you can try the Number.ToText function to convert the type of the list to text.
= Table.RemoveColumns(#"Changed Type", List.Transform(pixellist, each Number.ToText(_)))If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
parry2k
Super User
Super UserAnonymous what is pixellist?
the list of zones I need