I am trying to get one line for every unique part number that shows all the ID_LINES across instead of creating multiple records if they have multiple id lines. Can I use dconcat for this? If so how would that work? I also attached some images that might help you.
What I am trying to achieve is a query that looks like this
774403074007 BP A-210 RV.4(13WC0562)/ PN 507-T-043/BP K03-7140-118
instead of a query that looks like this
774403074007 BP A-210 RV.4(13WC0562)/
774403074007 PN 507-T-043/BP K03-7140-118
Any help what be appreciated