concatenate two tables to one

[gidon]

Hello

I have two table

1 - act   with 2000 rows

2 - tab1 with 3000 rows

i want to have tab1 into act 

and get one table named act that have 5000 lines

thanks

gidon

I want to

[MattAllington]

I created a video for you to show you how to do it.  https://www.youtube.com/watch?v=uAAOTi0VczA 

[gidon]

Hi Math

The Append Function succed and I have now two tables one contain the two of them

the other table .

I do not the the other table , as it is combined the the Act table  .

do i have now duplicate tables  .

if i delete it , i will have the data in the next reload .

in qlik i prepare the table then concatnet them together  .

and drop the table , but the the script that I need for the next reload  .

how does ir works in power BI

can you calify it

thanks

gidon

[MattAllington · Accepted solution]

To Get rid of the duplicate tables, right click on the table you don't need loaded (left hand side in the queries view) and disable "Enable Load".  This keeps the query (that you need) and simply doesn't materialise it in the data model.

[gidon]

thanks