Finding unique combinations from two nodesets

J

johkar

I could use some help with coming up with all unique combinations of
location@id and the coverageClass nodes

So what I want to end up with is xml that would be:
<combo>
1 Class1
1 Class2

<?xml version="1.0" encoding="UTF-8"?>
<company>
<company_bs>
<company_info>
<location>
<loc id="1"/>
</location>
<location>
<loc id="2"/>
</location>
<location>
<loc id="3"/>
</location>
<business>
<businessType>
<businessClass>
<class>
<coverageClass>Class1</coverageClass>
</class>
</businessClass>
<businessClass>
<class>
<coverageClass>Class2</coverageClass>
</class>
</businessClass>
<businessClass>
<class>
<coverageClass>Class3</coverageClass>
</class>
</businessClass>
<businessClass>
<class>
<coverageClass>Class4</coverageClass>
</class>
</businessClass>
<businessClass>
<class>
<coverageClass>Class5</coverageClass>
</class>
</businessClass>
</businessType>
</business>
</company_info>
</company_bs>
</company>
 
J

johkar

Sorry to top post, I accidently submitted. I need to end up with all
the unique combinations.
<company>
<combo><loc>1</loc><class>Class1</class></combo>
<combo><loc>1</loc><class>Class2</class></combo>
<combo><loc>1</loc><class>Class3</class></combo>
<combo><loc>1</loc><class>Class4</class></combo>
<combo><loc>1</loc><class>Class5</class></combo>
<combo><loc>2</loc><class>Class1</class></combo>
<combo><loc>2</loc><class>Class2</class></combo>
<combo><loc>2</loc><class>Class3</class></combo>
<combo><loc>2</loc><class>Class4</class></combo>
<combo><loc>2</loc><class>Class5</class></combo>
<combo><loc>3</loc><class>Class1</class></combo>
<combo><loc>3</loc><class>Class2</class></combo>
<combo><loc>3</loc><class>Class3</class></combo>
<combo><loc>3</loc><class>Class4</class></combo>
<combo><loc>3</loc><class>Class5</class></combo>
</company>
 
P

Peter Flynn

johkar said:
Sorry to top post, I accidently submitted. I need to end up with all
the unique combinations.
<company>
<combo><loc>1</loc><class>Class1</class></combo>
<combo><loc>1</loc><class>Class2</class></combo>
<combo><loc>1</loc><class>Class3</class></combo>
<combo><loc>1</loc><class>Class4</class></combo>
<combo><loc>1</loc><class>Class5</class></combo>
<combo><loc>2</loc><class>Class1</class></combo>
<combo><loc>2</loc><class>Class2</class></combo>
<combo><loc>2</loc><class>Class3</class></combo>
<combo><loc>2</loc><class>Class4</class></combo>
<combo><loc>2</loc><class>Class5</class></combo>
<combo><loc>3</loc><class>Class1</class></combo>
<combo><loc>3</loc><class>Class2</class></combo>
<combo><loc>3</loc><class>Class3</class></combo>
<combo><loc>3</loc><class>Class4</class></combo>
<combo><loc>3</loc><class>Class5</class></combo>
</company>

If the document really is laid out like that, then use

$ grep combo test.xml|sort|uniq
<combo><loc>1</loc><class>Class1</class></combo>
<combo><loc>1</loc><class>Class2</class></combo>
<combo><loc>1</loc><class>Class3</class></combo>
<combo><loc>1</loc><class>Class4</class></combo>
<combo><loc>1</loc><class>Class5</class></combo>
<combo><loc>2</loc><class>Class1</class></combo>
<combo><loc>2</loc><class>Class2</class></combo>
<combo><loc>2</loc><class>Class3</class></combo>
<combo><loc>2</loc><class>Class4</class></combo>
<combo><loc>2</loc><class>Class5</class></combo>
<combo><loc>3</loc><class>Class1</class></combo>
<combo><loc>3</loc><class>Class2</class></combo>
<combo><loc>3</loc><class>Class3</class></combo>
<combo><loc>3</loc><class>Class4</class></combo>
<combo><loc>3</loc><class>Class5</class></combo>

Otherwise you'll need XSLT or a similar tool to perform the extraction.

///Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top