repeating elements
Moderators: chulett, rschirm, roy
repeating elements
Hi Folks,
- <measure-group ID="X">
- <p1>
<C>Y</C>
<D />
<E />
- <p2>
<p2-number>ABC</p2-number>
<eligible-instances>16</eligible-instances>
<meets-performance-instances>28</meets-performance-instances>
<performance-rate xsi:nil="true" />
</p2>
</p1>
- <p1>
<C>Y</C>
<D>2011-04-01 00:00:00</D>
<E>2011-06-30 00:00:00</E>
- <p2>
<p2-number>EFG</p2-number>
<eligible-instances>1</eligible-instances>
<meets-performance-instances>2</meets-performance-instances>
<performance-rate xsi:nil="true" />
</p2>
</p1>
target xml output stage
target xml output stage
i am getting these elements repeated for all the rows
<C>Y</C>
<D>2011-04-01 00:00:00</D>
<E>2011-06-30 00:00:00</E>
i want the above to appear only once.
things i have done.
made this column <p2-number> as KEY.
aggreate all rows check boxed in target output stage.
- <measure-group ID="X">
- <p1>
<C>Y</C>
<D />
<E />
- <p2>
<p2-number>ABC</p2-number>
<eligible-instances>16</eligible-instances>
<meets-performance-instances>28</meets-performance-instances>
<performance-rate xsi:nil="true" />
</p2>
</p1>
- <p1>
<C>Y</C>
<D>2011-04-01 00:00:00</D>
<E>2011-06-30 00:00:00</E>
- <p2>
<p2-number>EFG</p2-number>
<eligible-instances>1</eligible-instances>
<meets-performance-instances>2</meets-performance-instances>
<performance-rate xsi:nil="true" />
</p2>
</p1>
target xml output stage
target xml output stage
i am getting these elements repeated for all the rows
<C>Y</C>
<D>2011-04-01 00:00:00</D>
<E>2011-06-30 00:00:00</E>
i want the above to appear only once.
things i have done.
made this column <p2-number> as KEY.
aggreate all rows check boxed in target output stage.
hard to tell, but it "looks" like p2 is your "inner" repeating group, and p1 is the "parent". ....and the C and D cols are desired to be at the "parent" level.
One would guess that the xpath for this looks something like:
.../p1/C/text()
.../p1/D/text()
.
.
.
.../p1/p2/p2_number/text()
etc.
Make sure the only "key" selected for this link is "inside" p2. ...such as P2 number.
Ernie
One would guess that the xpath for this looks something like:
.../p1/C/text()
.../p1/D/text()
.
.
.
.../p1/p2/p2_number/text()
etc.
Make sure the only "key" selected for this link is "inside" p2. ...such as P2 number.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Not sure....but carefully check your incoming data. And run with a tiny number of input records that you are intimately familiar with.
I didn't have time to absorb all of your data values, but it "looks" like you want to have one set of repeating groups for the single combination of npi/tin numbers that are at the top....but...
...for the same npi/tin combination, your dates are different. Find out why. That may not be the issue, but it would certainly be something to dig into.
Ernie
I didn't have time to absorb all of your data values, but it "looks" like you want to have one set of repeating groups for the single combination of npi/tin numbers that are at the top....but...
...for the same npi/tin combination, your dates are different. Find out why. That may not be the issue, but it would certainly be something to dig into.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
ahh right
thanks for your time ernie,
from your suggestion if found the issue is the repeating group, its a data issue,Not sure....but carefully check your incoming data. And run with a tiny number of input records that you are intimately familiar with.
I didn't have time to absorb all of your data values, but it "looks" like you want to have one set of repeating groups for the single combination of npi/tin numbers that are at the top....but...
...for the same npi/tin combination, your dates are different. Find out why. That may not be the issue, but it would certainly be something to dig into.
thanks for your time ernie,
No problem. Glad to be of help.....
..for anyone reading this, keep in mind that it's not just the syntax that will impact what your resulting document looks like. In this case there were "two" records at the higher level, so it had no choice but to cut another parent group.
Know your data.
Ernie
..for anyone reading this, keep in mind that it's not just the syntax that will impact what your resulting document looks like. In this case there were "two" records at the higher level, so it had no choice but to cut another parent group.
Know your data.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>