Flatten array of multiple value


#1

Hello,
my table contain 2 columns with an array each.

Column A: [A,B]
Column B: [1,2]

I wanna retrieve 2 row:

Row x: A | 1
Row y: B | 2

At the moment using flatten i retrieve 4 rows:

Row x: A | 1
Row y: A | 2
Row j: B | 1
Row k: B | 2