Data table value cell select and value substitution

Beginners
, , ,
1

Hi all,

So the final goal is to assign RGB or numerical values to an existing data table’s specified cells based on keywords found within the cells(comments column of the data_table1). This will be used to assign a color to an instance based on its index value relative to the data table I want to modify.

First I isolate the column containing the comments, then to search for the keywords I want, I am using a select DAT with a modified select by row condition parameter.

Screenshot 2021-03-01 102302
Screenshot 2021-03-01 102302747×576 98.2 KB

image
image455×542 12.2 KB

Where I am stuck is once I isolate the cells where the keywords are found I am not sure of how to assign the numerical value and reinsert them in the original table since the select DAT does not retain the original index row numbers of the selected cells…

any hint would be appreciated,

thanks

Edit: File was removed. Twitter API keys were shared and visible.

2

Not sure I totally understand the goal here, but maybe this will get you started. Look at the red nodes.

Edit: Original File was removed. Twitter API keys were shared and visible.

DVAPX.toe (25.1 KB)