Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 Consis...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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])

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

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])