Power Query - Expand multiple tables (from Python dataframes)

[Anonymous]

I am having a problem that may have a simple answer but I can't find it in the forums.

I am running a Monte Carlo python script in power query that creates multiple panda dataframes.

The results is that you see multiple tables which you can expand individually and they have the correct results.

I would like to expand all of the tables seperately as they have different formats and I am not sure how to achieve this. The results would be up to 5 seperate tables (dataset, df1, df2, df3, df4).

I can not run the same query multiple times and expand a different table each time as monte carlo is based on random data so each time you run it you get fifferent answers and the tables are related to each other.

I can not expand all into one flat file as they have different schemas.

Any suggestions would be appreciated.

[CNENFRNL · Accepted solution]

@Anonymous , you might simply create new queries referencing this query (assume the name is "py tables"). For instance, expanding the table in line with "dataset" is

= #"py tables"[Value]{0}

then #"py tables"[Value]{1}, ...{2}, ...{3}, etc.

[Anonymous]

Thanks. That fixed it 👍