on 03-16-2017 10:06 AM
Hello PI experts,
i need a help in the below mentioned scenario.
i need to group 2 records REC10 and REC20 based on one common field value.
there is one common filed NUMREGD if the value in both the records are equal than i need to make it in 1 set. i have achieved it.
please note i have achieved it when the file is coming in the below format.
REC10
REC20
REC10
REC20.. so onn
like 1st record is REC10 2nd record REC20 REC10 REC20...so onn
i am facing the issue when the file is like
REC10
REC20
REC10
REC10
REC20
in the above case the grouping is happening not in proper way like
in the above highlighted REC10 , the corresponding REC20 is missing, in that case it is taking the next REC20 and grouping them.
now my requirement is if REC20 does not present than we need to group only 1 REC10.
like
1st group
REC10
REC20
2nd group
REC10
3rd group
REC10
REC20.
can some one help me on this?
thanks a lot in advance.
Best regards
Prudhvi.test-result.jpg
Hi Prudhvi,
Can you please provide the complete structure of source, so that we may provide you a solution.
Also let us know if the common field NUMREGD value is same for the consecutive set of Records REC10, REC20 or is it occurring in random?
(Attach a sample source XML)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.