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.
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,
Edit: File was removed. Twitter API keys were shared and visible.