XML parsing to JSL Help

BagOfMapsFish37 — Fri, 11 Aug 2023 18:02:25 GMT

Hi Everyone,

I have been stuck on this XML parsing data to JSL for awhile, I can do it at one level but not at 2 levels.

I have this XML as below:

</Menu>

</Menu>

I need the output table to look like this one:

AAA_XXX	AAA_YYY	BBB_XXX	BBB_YYY
-11.9	7.1	-1.9	4.1

So far, I have this JSL code but it can only do IF condition at 1 level, but not at 2 levels for Menu and Item.

On Element( "Item",
			Starttag(
				If( XML Attr( "name") == "XXX", 
					column( dt, "AAA_XXX")[row()] = Num( XML Attr( "value"))/10;
				);
				If( XML Attr( "name") == "YYY",
					column( dt, "AAA_YYY")[row()] = Num( XML Attr( "value"))/10;
				);
                                If( XML Attr( "name") == "XXX", 
					column( dt, "BBB_XXX")[row()] = Num( XML Attr( "value"))/10;
				);
				If( XML Attr( "name") == "YYY",
					column( dt, "BBB_YYY")[row()] = Num( XML Attr( "value"))/10;
				);
)

Can you please kindly help me out?

Thank you.

Re: XML parsing to JSL Help

jthi — Fri, 11 Aug 2023 18:49:18 GMT

I would most likely start by trying the interactive XML import wizard

From here you can clean the data and modify it if needed and then you can split it

JMP is able to record most of the steps you need to get here (check enhanced log and source scripts of tables)

Re: XML parsing to JSL Help

Craige_Hales — Fri, 11 Aug 2023 23:36:14 GMT

I like it!

topic XML parsing to JSL Help in Discussions

XML parsing to JSL Help

Re: XML parsing to JSL Help

Re: XML parsing to JSL Help