CircuitCircuit: ( One Child may have more then one parents & One parent may have more then two childs )
These Hierarchy is not fixed , Depends on services the circuit hierarchies changes
ParentCktid ChildCktid
100 102
101 102
100 103
103 104
Service: ( Service can be associated with any child circuit )
serviceid Circuitid
S1 102
S2 103
S3 104
Requirement is we need to find the dependency Services for each circuit.
Expected out put :
Cktid Serviceid
102 S1
103 S2
104 S3
101 S1
100 S2
100 S3
In Pl SQL written while loop inside functions & functions are called from SQl stmt, But customer requirement is need to execute this business logic from Qlikview ( We don't have option to user SQL statement from Qlikview bcz of performance impact ).
I check the option to write macro - using Vbscript but we have to use the .Qvd file.
