Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit777
Specialist
Specialist

Data scenario

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

2 Replies
vinieme12
Champion III
Champion III

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?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anil_Babu_Samineni

What was the Expected output to see on UI?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful