Field concatenation

[FumaniMlambo]

Please help I am relatively new to the Power I platform. I have 2 tables, a Device table containing DeviceName, categoryID and other fields. I also have a Category table that contains CategoryName and Description. How can I go about joining the DeviceName values from the the Device table to the CategoryName and Description from the Category table to create a new merged table with the respevtive values. 

[jbwtp · Accepted solution]

Hi @FumaniMlambo,

Are you asking how to merge tables? This is this button in the main menu:

In your case, I guess, this is merge on the Category ID column.

Cheers,

John