I have an issue which I couldn’t figure out,yet.
Following Scenario: In the first table, I have a column which can look like this, a bunch of keys. The length of the overall string, as well as the single elements can variate alot (length and position):
ROW 1: ,c5411,abc,rbst,c41,caat,nbcat,nbfact,nbfcpex,nbfcpin,
ROW 2: ,c12281,gdesge1,gfase1,gsocce2,c113e,cprdta,reqrpq,c1820,c2,cactio0,ccbat,gmat,
In a second table, I have those elements in singular representation, such as:
ROW 1: ,c5411,
ROW 2: ,c12281,
I would like to join those two tables following the logic if ROW 1 from table 2 is an element of the long string of ROW 1 in table 1, then join the information.
In SQL I would work here with sth. like INNER JOIN … CONTAINS (table2.table2column, table1.table1column)
Cross Join is too computationally expensive. Cell Splitter and then joining is too variable, as I don’t know with how many columns I will end up with.