Forum Discussion
Resolver IExpand column in power query
Hello, now I'm not sure what this is suppose to be but I'll try to explain. The following image is from a power query on a sharepoint list :
What excactly does this do? Am I getting more columns from this columns or more rows? Is this a table within table? Can I put this in a new table?
Thanks.
Hi 314mp_M0th4 ,
The Expand icon in the column header of a structured column in Power Query allows you to expand the contents of that column into additional columns. This means that you will get more columns from that column. When you expand a structured column, you are essentially creating a table within a table, where the expanded columns become the new columns of the table and the original column becomes a reference to the nested table. You can then use the expanded columns to create a new table or merge with other tables. You can make a copy of the original table, then expand the columns you want on the copied table, select the columns you want to keep, right-click and select Delete Other Columns to delete the other columns, then click Close and Load to create a new table with the selected columns.
Please refer to the following document for more information.
Work with a List, Record, or Table structured column (Power Query) - Microsoft Support
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi 314mp_M0th4 ,
The Expand icon in the column header of a structured column in Power Query allows you to expand the contents of that column into additional columns. This means that you will get more columns from that column. When you expand a structured column, you are essentially creating a table within a table, where the expanded columns become the new columns of the table and the original column becomes a reference to the nested table. You can then use the expanded columns to create a new table or merge with other tables. You can make a copy of the original table, then expand the columns you want on the copied table, select the columns you want to keep, right-click and select Delete Other Columns to delete the other columns, then click Close and Load to create a new table with the selected columns.
Please refer to the following document for more information.
Work with a List, Record, or Table structured column (Power Query) - Microsoft Support
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.