Forum Discussion
Merge different Tables
Hi,
you can simply use fill down on a duplicated column then append and filter (see the attached file)
If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
No I really need to split in 2 tables, because these 2 tables have different fields. Sorry I did not want to make the explanation of the issue too complex and omited that.
My csv files looked like that:NewCustomers
Name Date ProductCust A xyz abc
Cust B
Cust C
...
BLANK line
LostCustomers
Name Date Reason
Cust D ghj blabla
that works nicely, and is straight forward.
An additional question: how do I split now the table that they appears as different tables in my Power BI (when I close Power Query). Do I need to keep the original query for New Customers and do a copy/paste to create a new query with a different Table.SelectedRows for the Lost Customer Table. Or there is something easier?
Hi,
i don't know if i understand well your question.
I think you can also use a unique table (see the new file)
No I really need to split in 2 tables, because these 2 tables have different fields. Sorry I did not want to make the explanation of the issue too complex and omited that.
My csv files looked like that:NewCustomers
Name Date ProductCust A xyz abc
Cust B
Cust C
...
BLANK line
LostCustomers
Name Date Reason
Cust D ghj blabla