Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Copy column from one table to another table

Hi,   I am trying to copy the value from a column (self) from a table called GetIssues to another table called 49407. I created a new column called Self in 40407 and I tried to use LOOKUPVALUE but...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    One sample for your reference, please check the following steps as below.

     

    1. Insert index column in both table in power query.

    2. Close and apply, then we use the LOOKUPVALUE to get the excepted result.

    Self in 40407 = LOOKUPVALUE(GetIssues[Self],GetIssues[Index],'49407'[Index])

     

    For more details, please check the pbix as attached.

     

     

     

  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

     

     

    merge This should help you.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Quick question that it might resolve my issue.

How can I create a new table in the query editor and add a column using the LOOKUPVALUE as mentioned before?

I am looking to create a new table and copy all the information from GetIssues[Self] to a new table with a new column.

Thanks in advance for your help 

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

 

merge This should help you.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel