Appending tables using M...

[Matty]

Hi,

I've created a new table (table2) by transforming data from an existing table (table1). I would now like to append some other data to table2 from table1.

I can do this quite easily by creating a new table and combining the two tables, but I'd like to do it all within one script to avoid the creation of a further table.

Can this be done? If so, what is the correct syntax?

I've tried:

#"Combine Tables" = Table.Combine({table2, Table.SelectColumns(table1,{"1Column", "2Column", "3Column"})})

But it throws up a cyclic reference error.

Cheers,

Matty

 

[Matty]

Never mind - figured it out!

I'm slowly getting my head around M - promise!

Cheers,

Matty

 

[Norie]

Matty

It would be interesting to see what solution you arrive at, could you post it?

 

[Matty]

Hi Norie,

I should have referenced the previous step in my code.

Corrected version below:

#"Combine Tables" = Table.Combine({[COLOR=#ff0000]#"Filtered Rows"[/COLOR], Table.SelectColumns(table1,{"1Column", "2Column", "3Column"})})

Cheers,

Matty