Dynamic mapping : user can select pairs key_value

[JPollet]

Hi everyone !
For the purposes of dynamic mapping, I’m looking for a component in which the configuration allows user to select for each row in a column, a value taken in another column (or table which is more logical).
For exemple, let say we have a list of keys (arbitrary and variable number of and the component may present all the keys) :

key_names
key_1
key_2
key_3
key_etc

and a list of values :

values
value_1
value_2
value_3
value_etc

The configuration of the component must present a line for each key names and a selection list to select one of the values.
Number of key names and of values can vary and the component configuration has to be dynamic.
Is it possible (yes I suppose) and with out coding nodes ?

Thanks !
Joel

[k10shetty1]

Hello @JPollet,

Can you please provide some dummy data and an example of what you are expecting from the given data?

Best,
Keerthan

[JPollet]

Hello @k10shetty1,
Here a generic example : given keys and values, the problem is how can this could be independant of the number of key_names. The result is just the association keys ↔ values choosen in the dynamic view of the component.

dynamic_mapping.knwf (26,3 Ko)

Maybe I missed something obvious !

Best,
Joel

[k10shetty1]

Hello @JPollet,

This can be achieved using the Table Editor (JavaScript) node. In the Editor tab of the node select the column to be used for dropdown. See an example below.

Hope this helps.

Best,
Keerthan

[JPollet]

Hi @k10shetty1 and thanks !
I had tried this but completly forgotten that it’s necessary to double click in the column to have the dropdown list… It’s a pity : my apologies

Thanks again,
Best,
Joel