Dynamically mapping integer to string value in table

[Michael_Hayworth]

Hello all,

I am trying to map an integer to a string value in a table column, similar to the post here:

Mapping integer to a string in a table column

How do I replace integer values of a column with a corresponding text. We have a use case where an integer column represents a state, these state can be mapped to a string name. Instead of displaying a state We want to display a text using a map. Map = {1: 'Created', 2:'Pending', 3:'Done'} cell value = 1, text to display in column = Created We tried using transformer and mapper but how do we access the cell value in a transformer. Please help or share any references if any

The difference is I would like to do it dynamically. It is a table of clients, and I want to find the originating_lawyer. This is a foreign key and I am using the built in retool database.

Without any mapped value the column returns the integer that is the ID from the lawyer table.

I want to take this integer "1" use it to return the name and avatar link of the correct lawyer from the lawyer table. Then display the name and avatar of the correct lawyer.

Any assistance would be greatly appreciated!.

Thank you,
Michael

[matth]

If db, what about using a join in your SQL query?

[edurmush]

Hi @Michael_Hayworth, can you give more details about your tables and data (or similar for privacy) to imagine the scenario?

[Michael_Hayworth]

Thanks both @matth and @edurmush for the quesitons.

The table looks like this (a snapshot from a table of clients:

originating_lawyer is a foreign key from table 'clients' to a table 'lawyers'.

Instead of displaying 1 (the foreign key) in my UI table I would like to display the lawyers name. Hope that makes some sense.

Thanks
Michael

[edurmush]

As @matth said, you can use a join on your SQL query. But if they come from separated data sources then you can use lodash's find method like:

How to fix this value string in a table?

{{ _.find(formatDataAsArray(query22.data), { user_id: item }).street }} This piece of code must work for you. You need to delete unnecessary curly brackets.

If you need more detail how to use them in your situation please let me know.