Use a result query as a table for the next iteration [Solved]

[Anonymous]

Hello everybody,

I'm trying to use Power query and Excel as a kind of Database, maybe it's not the good solution, but I would like your advice.

As my english isn't the best, I made a small drauwn to explain : 

I would like to be able to use a result query as the main query the next month, so I can recursively add data each month :  The Yellow arrow is my problem I guess !

Thank you for your help

Pierre

PS unable to use the drag and drop function to add a xlsx file ... sorry for that

[JamesRobson]

@Anonymous could you use a blank query and just append each month in?

Fake Data tables

Start with blank query then append each month/table and it'll keep growing

let
Source = #table(null,{}),
#"Appended Query" = Table.Combine({Source, #"Jan Data", #"Feb Data"})
in
#"Appended Query"

Think that gives the result you are after?

Thanks,

[Anonymous]

Hi, 

Is it more clear with this snapshot ?

The "ID" column is the mail

Thanks

[Anonymous · Accepted solution]

Hello,

I found a easy way to answer my problem :

- Create a "connexion only" on first Table (AAA)

- Create a connexion on the second Table (BBB), make your modification (Append ...), Save and Publish in the Workbook

- At this step, you should have a new Table named BBB_2, for example

- Delete the entire Table BBB

- Rename the Table BBB_2 => BBB

- That's all folks

It works for me, thank you for your help everybody

[Anonymous]

At least, her is a snap of my tables : 

[AntrikshSharma]

@Anonymous If there is no way to tell the month from the data then the file should have some indication, otherwise how will you define logic?

[Anonymous]

I have to precise : there isn't any kind of calculation, it's just some tables like "Name, Surname, Mail, ..."

I try to add a link to my file, 

Regards

[AntrikshSharma]

@Anonymous It is doable with List.Accumulate, you can post the data on google drive and create a shareable link.