Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Not displaying all element in XML extractor in U-Sql #131

Open
lalithakiran opened this issue May 7, 2018 · 0 comments
Open

Not displaying all element in XML extractor in U-Sql #131

lalithakiran opened this issue May 7, 2018 · 0 comments

Comments

@lalithakiran
Copy link

lalithakiran commented May 7, 2018

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( 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

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant