Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a data like below.
There is a start point and end point. eg I can go from A to B, or E to F.
But I can reach from A to B via C as well.
I want to know all the possible combinations between two points.
eg A to B can be reached by two ways .
1. directly from A to B
2. A to C then C to B.
Start End
A B
E F
A C
C B
Please help.
Thanks
try
MAIN:
LOAD * INLINE [
Start,End
A,B
E,F
A,C
C,B
];
Left JOIN(MAIN)
LOAD Start as End
,End as End2
RESIDENT MAIN;
How many levels to do you have?
What was the Expected output to see on UI?