Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Sample XML: <table> <G1> <COLUMN4>09999999</COLUMN1> <COLUMN2>ABC</COLUMN2> </G1> <G1> <COLUMN4>08999999</COLUMN1> <COLUMN2>XYZ</COLUMN2> </G1> </G1> <G1> <COLUMN4>9999999</COLUMN1> <COLUMN2>XYZ</COLUMN2> </G1> </table> From above xml, there are two records the column4 starting with 0 and should get the same in count in…