Splitting a fields values into a seperate field by a third field

[vanceinc]

I want to be able to split the TID field into two new fields (Ingress_TID and Egress_TID) by correlating against the OMS_ID which is the same ID number for both.  

Example data:

TID                                      PORTAID                  OMSID

BLTNMNFSWP001	1/7	oms-100483
MNNTMNICWP001	3/13	oms-100483

in the end want it to transform to 

Ingress_TID                               Egress_TID                         PORTAID             OMSID
BLTNMNFSWP001                                                                      1/7                     oms-100483

                                                      MNNTMNICWP001               3/13                  oms-100483

Any help would be great.  Thank you!!

[isoutamo]

How you are knowing which event is ingress an$ which egress?

[vanceinc]

Nothing distinctive to pin point which is which.  We could add the Ampid field and go by the lowest number as the ingress and then the highest number as egress.  

TID                                 PORTAID   AMPID      OMSID

COLNNYEJWP001	1/13	3160113	oms-100486
TROYNYDWWP001	1/6	3380106	oms-100486