Smart way to pick the right value from configuration table

[eacy]

Hi,

I'm searching for a smart way to pick the right value from a configuration file.

I have a table where I want to assign a certain value in a calculated column "Profile" based on the values in some of the other columns.

Here is an example table named "Issues":

I would like to compare the values in "Category 1", "Category 2" and "Category 3" with the value in the configuration table name "Profiles" if there is an exact match in "Category 1, "Category 2" and "Category 3" I want this value from the Profiles[Name] to appear in the calculated column named Issues[Profile]

Here is a example table named "Profiles":

i would like to be able to extent the number of Categories quiet easy.

Any suggestion is appriciated.

[BhaveshPatel · Accepted solution]

Hi You can achieve this using one step process of merging two queries in Query Mode. You can see in attached screenshots.

Choose all three columns Category 1,2 and 3 while merging both queriesExpand and Rename new columnfinal result

Thanks & Regards,

Bhavesh

[eacy]

Hi Bhavesh,

Briliant, simple and neat just what I needed, thanks