Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I am actual dataQuery is different from what I had posted in the question as the question contain pseudo code, replica of my original. Can I email you my original dataQuery if this is not an intrusion?
-
Product_Number is not hard coded in the actual query, here I have put the sample query to generate the output which is alike my real query.
-
Data Structure is modified to have nested elements, correct me If I am wrong. Thanks