Combine Partial Routes into full routes The Next CEO of Stack OverflowIs it possible to force Excel recognize UTF-8 CSV files automatically?Excel VBA lookup issueHow to query a MS-Access Table from MS-Excel (2010) using VBAExcel connect to Access with low performanceMultiple Data Range in Pivot Table using VBAImport textfile into MS Access Table on a machine without Office ProfessionalThe object invoked has disconnected from its clients - VBA- SQL QueryPartially renaming multiple Excel filesAccess 2016 VBA code to export to Excel, 'could not find installable ISAM'vba access using PictureEffects
Robert Sheckley short story about vacation spots being overwhelmed
Should I tutor a student who I know has cheated on their homework?
How did people program for Consoles with multiple CPUs?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
The King's new dress
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
WOW air has ceased operation, can I get my tickets refunded?
Why didn't Khan get resurrected in the Genesis Explosion?
Why does C# sound extremely flat when saxophone is tuned to G?
Rotate a column
MAZDA 3 2006 (UK) - poor acceleration then takes off at 3250 revs
How can I quit an app using Terminal?
How to get regions to plot as graphics
Only print output after finding pattern
If the heap is initialized for security, then why is the stack uninitialized?
Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?
How to write papers efficiently when English isn't my first language?
Can a caster that cast Polymorph on themselves stop concentrating at any point even if their Int is low?
How to safely derail a train during transit?
Customer Requests (Sometimes) Drive Me Bonkers!
What's the point of interval inversion?
How does practicing restraint and performing actions of merit purify the mind?
Science fiction (dystopian) short story set after WWIII
What is the difference between "behavior" and "behaviour"?
Combine Partial Routes into full routes
The Next CEO of Stack OverflowIs it possible to force Excel recognize UTF-8 CSV files automatically?Excel VBA lookup issueHow to query a MS-Access Table from MS-Excel (2010) using VBAExcel connect to Access with low performanceMultiple Data Range in Pivot Table using VBAImport textfile into MS Access Table on a machine without Office ProfessionalThe object invoked has disconnected from its clients - VBA- SQL QueryPartially renaming multiple Excel filesAccess 2016 VBA code to export to Excel, 'could not find installable ISAM'vba access using PictureEffects
I'm looking for a way to combine a table of partial routes (source - destination) into complete routes.
This picture shows two tables. With table one I can make Table 2 by hand.
Now I'm looking for a automated solution :-)
Since these are tables I was thinking of using Excel or Access as tool with the help of VBA.
May be there is standard naming for this principal but I could not find it yet.
So the source data is Table 1.
The goal is table 2.
Hope you can help!
Regards
Ceddy
excel vba ms-access
asked Mar 8 at 13:10
CeddyCeddy
11
add a comment |
I'm looking for a way to combine a table of partial routes (source - destination) into complete routes.
This picture shows two tables. With table one I can make Table 2 by hand.
Now I'm looking for a automated solution :-)
Since these are tables I was thinking of using Excel or Access as tool with the help of VBA.
May be there is standard naming for this principal but I could not find it yet.
So the source data is Table 1.
The goal is table 2.
Hope you can help!
Regards
Ceddy
excel vba ms-access
asked Mar 8 at 13:10
CeddyCeddy
11
1
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
1
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53
add a comment |
I'm looking for a way to combine a table of partial routes (source - destination) into complete routes.
This picture shows two tables. With table one I can make Table 2 by hand.
Now I'm looking for a automated solution :-)
Since these are tables I was thinking of using Excel or Access as tool with the help of VBA.
May be there is standard naming for this principal but I could not find it yet.
So the source data is Table 1.
The goal is table 2.
Hope you can help!
Regards
Ceddy
excel vba ms-access
asked Mar 8 at 13:10
CeddyCeddy
11
I'm looking for a way to combine a table of partial routes (source - destination) into complete routes.
This picture shows two tables. With table one I can make Table 2 by hand.
Now I'm looking for a automated solution :-)
Since these are tables I was thinking of using Excel or Access as tool with the help of VBA.
May be there is standard naming for this principal but I could not find it yet.
So the source data is Table 1.
The goal is table 2.
Hope you can help!
Regards
Ceddy
excel vba ms-access
excel vba ms-access
asked Mar 8 at 13:10
CeddyCeddy
11
asked Mar 8 at 13:10
CeddyCeddy
11
edited Mar 11 at 9:43
Ceddy
asked Mar 8 at 13:10
CeddyCeddy
11
asked Mar 8 at 13:10
CeddyCeddy
11
asked Mar 8 at 13:10
CeddyCeddy
11
11
1
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
1
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53
add a comment |
1
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
1
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53
1
1
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
1
1
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063922%2fcombine-partial-routes-into-full-routes%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063922%2fcombine-partial-routes-into-full-routes%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Can you give an example with a single set of data of how you would like the data to change? Your desired goal is not completely clear.
– David G
Mar 8 at 14:38
1
Hi David G, I will try to clearify my question more: The single set of data is Table1. The desired goal is Table2. Regards, Ceddy
– Ceddy
Mar 11 at 9:40
The "rule" is still not clear. What are the exact rules to filter for a "Node" from the original data set? Other than that, this should be straight forward.
– David G
Mar 11 at 11:39
No complex rules, just looking for a way to determine all complete routes. (Transfer Table 1 into Table 2) Is it clear that : - table1 contains partial routes and that Table 2 contains the complete routes? - The source and destination of table1 are nodes in table 2? - The order in Table1 is not ordered in a specific way?
– Ceddy
Mar 12 at 14:51
It is not clear to me how you get from table 1 to table 2. Again: please outline the rules you use to get the data from table 1 to table 2. And there must be a fixed set of rules, otherwise you could not do it, right? You can update these rules in your question.
– David G
Mar 13 at 7:53