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...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    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.

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

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
5 years ago

Thanks. That fixed it 👍