Hi,
I have a data table with a column of errors for each individual, which can have more than one error message per person concatenated, and there is a master table of errors, how is it possible to filter rows in the data table , leaving only the rows that have inconsistency messages contained in the master table?
ID ERROR
1 INSUFFICIENT CAPITAL
2 INSUFFICIENT CAPITAL, INSUFFICIENT DATA
3 INSUFFICIENT DATA, INCONSISTENT ID
4 INSUFFICIENT DATA, INSUFFICIENT CAPITAL, INCONSISTENT ID
Master table: ERROR
INSUFFICIENT DATA
INCONSISTENT ID
In this case they should only follow the id 2, 3 and 4 with a reference filter based on the error master.
It does not help me to make a cell splitter, because I can have n concatenated inconsistency messages, I was trying with a dictionary filter but it did not work for me.
Does anyone know how I can achieve what I need?
Hi @izaychik63 ,
Thanks for answering.
I have been testing with that node, however it doesn’t work for me, it also takes a long time to process as there is a lot of data.
I was able to solve it by doing a Cell Splitter to the inconsistencies column, then the columns resulting from the divisor I converted into a collection with Create Collection Column, and then that column resulting from the collection I applied an Ungroup, this way I already received a message of inconsistency per row and I was able to do a Reference Row Filter with the inconsistency master.
@daviddelos , it’s great you find solution working for you. In case of Rule-based row filter you can use $ID ERROR$ LIKE “*INSUFFICIENT DATA*” => TRUE rule to compare rows content to the Maser Table value.