how can we generate row values like 1 1 1 2 2 2 3 3 3 using col genera

how can we generate row values like
1
1
1
2
2
2
3
3
3
using col generator
plz let me know

Question Posted / surya

2 Answers
7634 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know..

Answer / koti

seq -----------cg------------seq

Take input file like
1
2
3
4
5
6
7
8
9
10

comming to CG

Column Method =Explicit
column Generate = Test

go to cg Porperties output ----Mapping----- map the test column----ok

next ,column---edit column meta data--columnname test--sqltype integer----parallel properties---genartor-
type=cycle,increment =1,intial vlue=1.

go to target file do link sort to outputfile

go to apt_config file
check how many node is their

if it 2 nodes
you just create one more node that means total 3nodes.

while runing a job run on 3 nodes.

you will get output like
1
1
1
2
2
2
3
3
3
4

Is This Answer Correct ?

5 Yes

0 No

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know..

Answer / peeyush sehgal

Take input file like 0 1 2 3 4 5 6 7 8 9
seq -> trans -> seq

in transformer, clear its partitioning and sort the data.
then in stage variable
initialize sv=1

if inputlink%3=0 then sv+1 else sv

populate sv in output column.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer