How to combine columns from differents tables in a single one, but in a vertical way ?

[Anonymous]

Hi Everybody,

I am stuck trying to combine 2 columns from differents tables in a single one

eg :

Table 1

aaaa

bbbb

ccccc

Table 2

dddd

eeee

ffff

I would like to create a new table looking like :

Table 3

aaaa

bbbb

ccccc

dddd

eeee

ffff

Thanks for you help 🙂

[Greg_Deckler · Accepted solution]

@Anonymous 

Table = UNION('Table1','Table2') or if you need specific columns then:

Table =

UNION(

  SELECTCOLUMNS('Table1',"Column",[Column])

  SELECTCOLUMNS('Table2',"Column",[Column])

)

[Anonymous]

Hi Greg

That was fast !  😁
I didn' know about the UNION function, I was trying with MERGE function or COMBINE..

I t works fine thank you for your help 👍