Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query - Expand multiple tables (from Python dataframes)

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.

 

 

 

  • 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.

2 Replies

Replies have been turned off for this discussion
  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

    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's avatar
      Anonymous
      Not applicable

      Thanks. That fixed it 👍