cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question
vanceinc
New Member
Member since: ‎09-09-2020
‎09-10-2020
Community Statistics
Posts 2
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎09-09-2020
View All

Re: Splitting a fields values into a seperate fiel...

by in Getting Data In
‎09-09-2020 12:18 PM
‎09-09-2020 12:18 PM
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 ... View more

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

by in Getting Data In
‎09-09-2020 11:52 AM
‎09-09-2020 11:52 AM
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!! ... View more
Labels
Contact Me
Online Status
Offline
Date Last Visited
‎09-10-2020 10:13 AM