hi, i have 3 fields (materialnum, seqnum, text)
the issue i have is:
1) If two text values in a Sequence number are the same, i need to take only the 1st text value but still pass the other row through but with a blank value for the text column.
from
(materialnum, seqnum, text)
1 01 a
2 01 a
into
1 01 a
2 01
thanks in advance
Data Manipulation
Moderators: chulett, rschirm, roy
Did you still have a question on how to do this?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Make sure the data is sorted, then use a Transform stage with a stage variable that store the last row's seqnum. If it is the same as this row's seqnum don't put a value in "text", otherwise do.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
hi,
yes i do, i have got it working for the following
from
(materialnum, seqnum, text)
1 01 a
2 01 a
into
1 01 a
2 01
but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables
from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 02 w
4 02 d
5 02 e
into
1 01 a
2 01
3 02 w d e
4 02
5 02
thanks
yes i do, i have got it working for the following
from
(materialnum, seqnum, text)
1 01 a
2 01 a
into
1 01 a
2 01
but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables
from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 02 w
4 02 d
5 02 e
into
1 01 a
2 01
3 02 w d e
4 02
5 02
thanks
mark_e
hi,
yes i do, i have got it working for the following
from
(materialnum, seqnum, text)
1 01 a
2 01 a
into
1 01 a
2 01
but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables
from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 02 w
4 02 d
5 02 e
into
1 01 a
2 01
3 02 w d e
4 02
5 02
thanks
yes i do, i have got it working for the following
from
(materialnum, seqnum, text)
1 01 a
2 01 a
into
1 01 a
2 01
but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables
from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 02 w
4 02 d
5 02 e
into
1 01 a
2 01
3 02 w d e
4 02
5 02
thanks
mark_e
It can be done with stage variables, but not the way the data is sorted, you would need to sort by materialnum and descending seqnum to make that work.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>