Forum Discussion

appsac1's avatar
appsac1
Helper I
4 years ago
Solved

having trouble with local model formula

i have a main table that is connected as a local model so i can't add any columns to it. for simplicity, lets say its a table of colors. column 1 is the color (blue, red, yellow), column 2 is a rando...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi appsac1 ,

    If you can't add columns in the main table, you can select Merge Queries>Merge Queries as New.

    Then add a custom column in the new merged table.

    New Color = if [Color]="Blue" then [Table2.Sub_color] else[Color]

    Then remove other unwanted columns and select remove duplicates of the whole table.

    Get the result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi appsac1 ,

If you can't add columns in the main table, you can select Merge Queries>Merge Queries as New.

Then add a custom column in the new merged table.

New Color = if [Color]="Blue" then [Table2.Sub_color] else[Color]

Then remove other unwanted columns and select remove duplicates of the whole table.

Get the result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.