Log In
Register
Home
Creating a Table From Two List Tables
Lee Baldock
Active Member
Members
Power Pivot
Power Pivot
Forum Posts: 5
Member Since:
August 11, 2018
August 11, 2018
Offline1
October 30, 2019 - 12:41 am
Hi,
I have two lists in PQ (both formatted as tables), one of dates and one of our production plant codes.
Is there a way of combining these to create a table with a row for each combination of date and plant code.
i.e. My dates are for a year (thus there are 365 of them), we have approx 150 plant codes, thus the end resulting table should have 54,750 rows
Thanks, Lee
See Answer
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1824
Member Since:
November 8, 2013
November 8, 2013
Offline2
October 30, 2019 - 4:25 am
Hi Lee,
In one of the tables, simply add a new column with this formula that refers to the other table:
=Table2QueryName
The new column will contain the same table in all rows. All you have to do now is to expand this new column into rows. (you should see this option in advanced options)
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Vishal Nevase, John Kobiela, Sue Hammond, Lia Ro, Malcolm Sawyer
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6355
Posts: 27792
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —