Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Icon for Helper IV rankHelper IV
9 years ago
Solved

New column by comining two columns from two different data sets?

Hi,   I have two simple datasets, and I want to combine two coloums from each table.  For instance: Lastname in the facility_contacts   and Country in the facilities In excel I would do: ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi Kristofferaabo,

     

    Please use Related method: 

    combine = Sheet1[name] & RELATED(Sheet2[last])

     

     

    If this works for you please accept it as solution and also like to give KUDOS.

    Best regards
    Tri Nguyen

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

Hi Kristofferaabo,

 

Please use Related method: 

combine = Sheet1[name] & RELATED(Sheet2[last])

 

 

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen