usql
usql copied to clipboard
Azure
Not displaying all element in XML extractor in U-Sql
I am new to U-Sql and trying to extract xml element. Here is my XML code.
<Dispositions> <Disposition>test 1</Disposition> <Disposition> test 2</Disposition> </Dispositions>
Trying to display all "Disposition" values. But final output displaying "Test 2" only. I have code as below.
`DECLARE @testFile string ="Marlboro20180301000000_child.xml";
@xmlElementRowPath= EXTRACT Disposition string
FROM @testFile
USING new Microsoft.Analytics.Samples.Formats.Xml.XmlExtractor("Dispositions",
new SQL.MAP<string,string>{
{"Disposition","Disposition"}
}
);
@words = SELECT Ar.word, COUNT(*) AS count FROM @xmlElementRowPath CROSS APPLY EXPLODE(new SQL.ARRAY<String>( Disposition.Split(','))) AS Ar(word) GROUP BY Ar.word; //ORDER BY count DESC; OUTPUT @words TO "test.csv" USING Outputters.Csv();`
Correct me about my mistakes.
Thanks Lalith
