Forum Discussion
Select Columns using existing data and Create a new table
I have the following data with me already.
Table 1 Consists of Column A , Column B , Column C
Table 2 Consists of Column D , Column E
Now i want to create a new table as
Table 3 Consists of Column A , Column D.
Note: Column A is of data type Text and Column D is of Data type Decimal Number.
Any help, suggestion on this will be of great help
Hi Anonymous ,
At first, you need to add an index column( start from 0 ) in the first table.
Then add a custom column like the following codes:
=Table.AddColumn(#"Added Index", "Column4", each TableB{[Index]}[Column4])
2 Replies
Do you have any IDs in your tables that should be used to match rows between tables? If yes, then merge the tables https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9
Or do you have two tables with no IDs but with the same number of rows in each table and want to merge them as is (row 1 with row 1, row 10 with row 10, last row with last row)? Add Index column to both tables https://support.microsoft.com/en-us/office/insert-a-custom-column-into-a-table-power-query-2dbb579a-915b-4ebd-b622-8e7f3d1d61a6?ui=en-us&rs=en-us&ad=us and then merge two tables by index columns.Hi Anonymous ,
At first, you need to add an index column( start from 0 ) in the first table.
Then add a custom column like the following codes:
=Table.AddColumn(#"Added Index", "Column4", each TableB{[Index]}[Column4])
