# Flatten array of multiple value

**URL:** <https://community.dremio.com/t/flatten-array-of-multiple-value/2986>\
**Category:** Uncategorized\
**Created:** [March 14, 2019, 3:14pm UTC](https://community.dremio.com/t/flatten-array-of-multiple-value/2986 "2019-03-14T15:14:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![marco](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/marco/32/1556_2.png) [@marco](https://community.dremio.com/u/marco)\
**Post date:** [March 14, 2019, 3:14pm UTC](https://community.dremio.com/t/flatten-array-of-multiple-value/2986/1 "2019-03-14T15:14:06Z")

</div>

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