Post by VPL630 on Aug 21, 2012 21:38:58 GMT
Hope this is an Easy question
I have two different files:
File 1 Has A Route Number and Registration from the countdown API data stream
File 2 Has A Registration, Company Name and Fleet Code for that Registration from a Fleet List
What I want to do is link the Company Name and Fleet Code for that Registration from File 2 into File 1 into 1 file
If you have no idea what I am talking about here is an Example
File 1: countdown API data stream
LineID Registration
1 LF52THV
1 LF52THX
1 LF52THZ
1 LF52TJO
1 LF52TJU
1 BX04AZW
1 BX04AZU
1 BX04AZZ
1 BX04BAA
1 BX04BAV
File 2: Fleet List
Registration Operator Operator_Name Fleet Number
LF52TJO GAL London General VWL 30
BX04AZZ GAL London General VWL 35
BX04BAA GAL London General VWL 36
BX04BBE GAL London General VWL 39
LJ59LZA AL Arriva London T 101
LJ59LXS AL Arriva London T 116
593CLT AL Arriva London T 93
LJ53BFL AL Arriva London VLA 22
LJ53BFN AL Arriva London VLA 24
LJ53BDE AL Arriva London VLA 27
LJ53BDU AL Arriva London VLA 30
LJ53BCY AL Arriva London VLA 45
LJ53BBU AL Arriva London VLA 55
SN61CXX TLN Abellio London 2418
SN61CYE TLN Abellio London 2423
SN61CYP TLN Abellio London 2431
What I want to do is have those files combine into one and for the registration in file 1 to be to linked to the registration in file 2 and all of the data connected to it.So I want a file like this:
LineID Registration Operator Operator_Name Fleet Number
1 LF52THV GAL London General VWL 27
1 LF52THX GAL London General VWL 28
1 LF52THZ GAL London General VWL 29
1 LF52TJO GAL London General VWL 30
1 LF52TJU GAL London General VWL 31
1 BX04AZW GAL London General VWL 32
1 BX04AZU GAL London General VWL 34
1 BX04AZZ GAL London General VWL 35
1 BX04BAA GAL London General VWL 36
1 BX04BAV GAL London General VWL 38
Is there anyway to do this
Thanks Dave
I have two different files:
File 1 Has A Route Number and Registration from the countdown API data stream
File 2 Has A Registration, Company Name and Fleet Code for that Registration from a Fleet List
What I want to do is link the Company Name and Fleet Code for that Registration from File 2 into File 1 into 1 file
If you have no idea what I am talking about here is an Example
File 1: countdown API data stream
LineID Registration
1 LF52THV
1 LF52THX
1 LF52THZ
1 LF52TJO
1 LF52TJU
1 BX04AZW
1 BX04AZU
1 BX04AZZ
1 BX04BAA
1 BX04BAV
File 2: Fleet List
Registration Operator Operator_Name Fleet Number
LF52TJO GAL London General VWL 30
BX04AZZ GAL London General VWL 35
BX04BAA GAL London General VWL 36
BX04BBE GAL London General VWL 39
LJ59LZA AL Arriva London T 101
LJ59LXS AL Arriva London T 116
593CLT AL Arriva London T 93
LJ53BFL AL Arriva London VLA 22
LJ53BFN AL Arriva London VLA 24
LJ53BDE AL Arriva London VLA 27
LJ53BDU AL Arriva London VLA 30
LJ53BCY AL Arriva London VLA 45
LJ53BBU AL Arriva London VLA 55
SN61CXX TLN Abellio London 2418
SN61CYE TLN Abellio London 2423
SN61CYP TLN Abellio London 2431
What I want to do is have those files combine into one and for the registration in file 1 to be to linked to the registration in file 2 and all of the data connected to it.So I want a file like this:
LineID Registration Operator Operator_Name Fleet Number
1 LF52THV GAL London General VWL 27
1 LF52THX GAL London General VWL 28
1 LF52THZ GAL London General VWL 29
1 LF52TJO GAL London General VWL 30
1 LF52TJU GAL London General VWL 31
1 BX04AZW GAL London General VWL 32
1 BX04AZU GAL London General VWL 34
1 BX04AZZ GAL London General VWL 35
1 BX04BAA GAL London General VWL 36
1 BX04BAV GAL London General VWL 38
Is there anyway to do this
Thanks Dave