Forum Discussion
Merge Question Between Data Tables with Shared Column
Rob, you may merge your first table with second one on WO_Description_ID and extract Remarks column. After that merge resulting table with second one on FINDINGS_ID and extract remarks as Remarks.1 column.
Select Remarks and Remarks.1 columns, on Power Query editor ribbon Add Column->Merge Columns, merge them with custom line feed separator #(lf). Or any one which you prefer. All remarks will be in resulting column.
Hi Rob,
Yes, it's better with screenshort or small sample which illustrates data logic. Like this
Hi Sergei,
Thanks for the reply. To clarify things, please see a screenshot of the first table named "WO":
As you can see there are two columns "WO_Description_ID" and "Findings_ID". There are for the most part sequential but the same numbering scheme. Each row is associated with a unique work order.
The second table below is in the same database and titled "WO_Remarks":
This has the first column where the "description ID" and "findings ID" from above have all been collectively dumped in a single column. I am after the content of the "remarks" column above but need to extract this text using the uniqe "ID" identifier. Since it is done this way, every row of the first table will correspond to two rows of the second table (one row for description and one for findings remark text).
How can I extract this data from the second table and tie to the correct individual row of the first table?
Thank you,
Rob
Rob, you may merge your first table with second one on WO_Description_ID and extract Remarks column. After that merge resulting table with second one on FINDINGS_ID and extract remarks as Remarks.1 column.
Select Remarks and Remarks.1 columns, on Power Query editor ribbon Add Column->Merge Columns, merge them with custom line feed separator #(lf). Or any one which you prefer. All remarks will be in resulting column.
Thanks SergeiBaklan ,
This solved my issue. It seems quite obvious what I needed to do now. Worked great.
Rgds,
Rob
