Skip to Content
0
Apr 08, 2015 at 08:00 AM

Mapping one ID with several entries

18 Views

Hi,

I got a problem I'm not sure how to resolve.

My data looks something like below. The numbers is representing a customer, and the text next to it what type of message that customer can use.

What I need is to take the unique customer number and tell the target side what messages this customer can use. Also, the optimal solution for my target side would be if each type of message could be represented as an "X". The messagetype needs to be in the same order for all customers.

123456 INVOICE

123456 ORDER

123456 ORDERRESPONSE

654321 ORDER

654321 DISPATCHADV

111111 INVOIC

So target could look something like this:

123456 ORDER, ORDERRESPONSE, INVOICE, ,

654321 ORDER, , ,DISPATCHADV

111111 , ,INVOICE

And the optimal solution:

123456 X, X, X, ,

654321 X, , ,X

111111 , ,X

So the "X" states what kind of message type it is, and the comma separates the message types from each other.

any idea how to solve this? I need to write this to a text file, so I guess I'm going to use content conversion.