Hi, I have a very simple problem, but I haven't found an obvious solution. I have a two table, A and B. Table A has field id. Table B has fields id1, id2 and id3. I need to filter A when it matches either id1, id2 and id3. I have tried to add this as a filtering condition to either the main or the lookup table, and it is not working - empty result. I am clearly missing something obvious. Any suggestion? Thanks.
Hi
you can do it using 3 subjobs, and joint using a tmap
A.id = B.id1 => put result in tmp.csv
A.id = B.id2 => put result in tmp.csv
A.id = B.id3 => put result in tmp.csv
At the end, remove dublicate in tmp.csv
