Hello,
I want to import a data set from (well formed) XML directly into a data table. This is something that Excel can do so I'm sure JMP can! The XML and the final data tables look like the examples below; there are a set of tests with results for individual pins, associated with a die, all part of an overall lot, with associated attributes such as tester or x,y coordinates (it's based on semiconductor test data, as you may have guessed!). The dataset could potentially be very long.
I know there is a Parse XML JSL function but I can't get my head around how to implement it in this situation. Any suggestions gratefully received!
Thanks, Matthew.
<FinalTest>
<Lot lot_id="BLAH" tester_type="J750">
<Die die_id="1" die_x="1" die_y="1">
<Test test_name="TEST1" unit="A">
<Pin pin_name="ABC" result="1234" />
<Pin pin_name="DEF" result="2345" />
</Test>
<Test test_name="TEST2" unit="A">
<Pin pin_name="XCV" result="414" />
<Pin pin_name="VBN" result="1351" />
</Test>
</Die>
<Die die_id="2" die_x="3" die_y="4">
<Test test_name="TEST1" unit="A">
<Pin pin_name="ABC" result="5433" />
<Pin pin_name="DEF" result="4321" />
</Test>
<Test test_name="TEST2" unit="A">
<Pin pin_name="XCV" result="6856" />
<Pin pin_name="VBN" result="5345" />
</Test>
</Die>
</Lot>
</FinalTest>
| lot_id | tester_type | die_id | die_x | die_y | test_name | unit | pin_name | result |
| BLAH | J750 | 1 | 1 | 1 | TEST1 | A | ABC | 1234 |
| BLAH | J750 | 1 | 1 | 1 | TEST1 | A | DEF | 2345 |
| BLAH | J750 | 1 | 1 | 1 | TEST2 | A | XCV | 414 |
| BLAH | J750 | 1 | 1 | 1 | TEST2 | A | VBN | 1351 |
| BLAH | J750 | 2 | 3 | 4 | TEST1 | A | ABC | 5433 |
| BLAH | J750 | 2 | 3 | 4 | TEST1 | A | DEF | 4321 |
| BLAH | J750 | 2 | 3 | 4 | TEST2 | A | XCV | 6856 |
| BLAH | J750 | 2 | 3 | 4 | TEST2 | A | VBN | 5345 |
