How to create a cartesian table

mtriguis · March 23, 2018, 9:45pm

Dear All, my first post, I need your help to create a Cartesian table. Which nodes to use?
Thanks in advance!

Table A

MyKeyA
KE
KA
KD
KO

MyKeyB, AmountB
K*, 1000

MyKeyA, MyKeyB, AmountB
K*, KE, 1000
K*, KA, 1000
K*, KD, 1000
K*, KO, 1000

s.roughley · March 24, 2018, 11:29am

Either Cross Joiner or Joiner node, depending on details.
Steve

mtriguis · March 25, 2018, 2:35am

Thank you @s.roughley, after many tries, I decided to go with SQLite