Matt Harrison
asked on
dconcat question
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
IM_KEY ID_LINE
774403074007 BP A-210 RV.4(13WC0562)/ PN 507-T-043/BP K03-7140-118
instead of a query that looks like this
IM_KEY ID_LINE
774403074007 BP A-210 RV.4(13WC0562)/
774403074007 PN 507-T-043/BP K03-7140-118
Any help what be appreciated
example1.PNG
example2.PNG
What I am trying to achieve is a query that looks like this
IM_KEY ID_LINE
774403074007 BP A-210 RV.4(13WC0562)/ PN 507-T-043/BP K03-7140-118
instead of a query that looks like this
IM_KEY ID_LINE
774403074007 BP A-210 RV.4(13WC0562)/
774403074007 PN 507-T-043/BP K03-7140-118
Any help what be appreciated
example1.PNG
example2.PNG
I assume you are talking about a report or a query you are exporting. There are several versions of concatenation functions available on the internet. Any one of them would be able to do this. Give it a whirl.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks that worked perfectly!!