Thanks for response ,
Our requirement is we have source file with 2 columns topology Id & it's Parent Nodes.
Each topology has only 2 nodes ( means 2 records for each topologyId ).
we need a table with below fields & one 1 record for each topologyId.
Topology ParentNode1 parentNode2
Now i am getting output using min & Max functions. Is there any alternate method for this requirement ?
Load Inscope_TOPOLOGYID,min(TOPNODEID) as Parent1,max(TOPNODEID) as Parent2
Try Like this
Load * inline [
122 , 103
Min(ParentNode) As ParentNode1,
Max(ParentNode) AS ParentNode2
Group by TopologyID
Thread98532.qvw 134.5 K