I have a workflow that loops through account ID numbers and builds a regression model for each. The dataset has many rows for each account so the Group Loop segments the table for each loop iteration.
It works perfectly for most of the data, but for certain account IDs, the value is not recognized when used as a joining column. The join returns an empty data table even though the value is definitely in both tables. Thus there is no data to feed the regression model and the workflow is useless for this entire account.
The account IDs are stored as Strings so I have tried stripping the whitespace and converting to numbers, but the value is still not recognized when I try to Join and Filter on it with many different nodes. I am copying the value directly from the table and trying to filter on it but it doesn’t work. What do I do when the value is clearly in the table but cannot be recognized or processed by any nodes?