Forum Discussion
Python - multiple tables
Hi cyborgdroid,
Tables in power query can be recongnized as pandas object directly, so you can simply call other tables by calling relevant pandas object. You can refer to this answer: https://stackoverflow.com/questions/51947441/power-bi-using-python-on-multiple-tables-in-the-query-editor/51947461.
Regards,
Jimmy Tao
I don't know how to take input from multiple tables in a convenient way, you can however Append two queries. Lets say you have two tables that looks like this.
// table 1 animal cost shark 100 horse 200 // table 2 year party 1999 yes 1998 no // result of append animal cost year party shark 100 null null horse 200 null null null null 1999 yes null null 1998 no
This script below shows how you drop the empty rows AND if you run it you will be able to select which of the dataset_out you are interested in. Just right click any (or both) tables and choose Add as new query. Power BI identifies all dataframes within the script and list them after you run the script.
dataset_out1 = dataset[["animal","cost"]].dropna() dataset_out2 = dataset[["year","party"]].dropna()
Thanks karlanka! That a good way to output to multiple tables. Input from multiple tables without pre-joining them in DAX is crucial though.