Forum Discussion
Merge Queries with multiple lookups
Thank you Allison.
I am testing the option of Split Column by Delimiterm using each comma as an occurrence and split into rows.
It appears that all the information contained on that row duplicates when there are multiple Equipment entries, leaving only one Equipment item per row.
ChrisDiener
On the Plant and Equipment - On Hire Query or copy of this query, right click on the Equipment column where you have the numbers seperated with comma, choose Split Column and on the dialog box, choose Rows under Advanced options, this will split the column into rows then you will be able to merge with the other table on the Equipment column:
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.
Thank you Ashish.