question

LPatrick avatar image
0 Votes"
LPatrick asked

Matching comma delimited items by position in set

I have two separate queries that I'm trying to combine in Power Query by a unique project ID.

The first query has two columns, one with a unique ID, and the other with a comma-delimited list of document names:

e.g.

Project# | Document Name


1-123 | Summary, Invoice
1-456 | Summary, Invoice, Contract

The second query has two columns, one with a unique ID corresponding to the first table, and the other with a comma-delimited list of document IDs:

e.g.

Project# | Document ID


1-123 | 4e40117f, 44d9bb10
1-456 | 990dfcf9, 87e34673, 9296580c

I've verified that the document name and its document ID are in the same position within their delimited lists, but I need help in combining them into one query which separates them into individual line items:

e.g.

Project# | Document Name | Document ID


1-123 | Summary | 4e40117f
1-123 | Invoice | 44d9bb10
1-456 | Summary | 990dfcf9
1-456 | Invoice | 87e34673
1-456 | Contract | 9296580c

Any ideas would be greatly appreciated!

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers