Data scenario

[ankit777]

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

[vinieme12]

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?

[Anil_Babu_Samineni]

What was the Expected output to see on UI?