Options
de-windowing process
Contributor I
Hey all together,
i have got a question about the de-windowing process. The following example should illustrate my question.
I would like to transform a windowed dataset into a single col:
c1 c2 c3
1 2 3
4 5 6
7 8 9
to
c
1
2
3
4
5
6
7
8
9
Has anyone a solution for me? :-\
Thx
i have got a question about the de-windowing process. The following example should illustrate my question.
I would like to transform a windowed dataset into a single col:
c1 c2 c3
1 2 3
4 5 6
7 8 9
to
c
1
2
3
4
5
6
7
8
9
Has anyone a solution for me? :-\
Thx
Tagged:
0
Answers
you can use Loop Examples with an embedded Loop Attributes. However, you will have to use a construct with Remember and Recall as proposed in this thread: http://rapid-i.com/rapidforum/index.php/topic,5209.0.html
In the inner loop you can use Extract Macro (with data value) and then Generate Data by User Specification with only one example and one column, containing the extracted value. In the end you have to Append all Example Sets, and you're done.
In the upcoming release 5.3.0 everything will be easier, you will just need the two loops without the Remember/Recall construct, because Loop Attributes will have a collecting data port as does Loop Examples.
Best,
Marius