Change values of a table based on filtering another table

[Elisa112]

Hi Experts

I have two tables based on assessment data, linked by an assessment ID, I need to change the categories of assessment from codes and values to something more meaningful but only for IS Assessment type. There are 8 codes and 5 Values.

Here is the example data and expected output

thanks in advance and appreciated

[Anonymous · Accepted solution]

Hi @Elisa112 , hello Rupak_bi, thank you for your prompt reply!

Please verify if the following sample test meets your requirements:

CodeTable:

ValueTable:

MappingCodeTable:

MappingValueTable:

Table relationship:

Apply a filter to the visual where Type equals IS:

Best regards,

Joyce

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

[Elisa112]

Thanks for the demonstration @Anonymous this works very well

Much Appreciated!

[Rupak_bi]

Hi @Elisa112 

create two master table defining the meaningfull words against the numbers for code and value. create relationship and display the words you wish to.