How to convert each row into a column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Harini....thanks for the reply, i think this logic will work, but how can I split the file into two ?
I tried using @INROWNUM in stage variable like below. Created stage variables for all the first nine rows and sending it to a seperate file....but what should i mention after else condition, i just dont want to read the row if it is not the 1st one ? Iam doing this in sequential mode.
TRANSFORMER
DERIVATION STAGE VARIABLE
IF @INROWNUM=1 then LkFrm_Src_Seq_Inserts.column1 else ? col1
IF @INROWNUM=2 then LkFrm_Src_Seq_Inserts.column1 else ? col2
IF @INROWNUM=3 then LkFrm_Src_Seq_Inserts.column1 else ?col3
IF @INROWNUM=4 then LkFrm_Src_Seq_Inserts.column1 else ? col4
IF @INROWNUM=5 then LkFrm_Src_Seq_Inserts.column1 else ? col5
IF @INROWNUM=6 then LkFrm_Src_Seq_Inserts.column1 else ? col6
IF @INROWNUM=7 then LkFrm_Src_Seq_Inserts.column1 else ? col7
IF @INROWNUM=8 then LkFrm_Src_Seq_Inserts.column1 else ? col8
IF @INROWNUM=9 then LkFrm_Src_Seq_Inserts.column1 else ? col9
I tried using @INROWNUM in stage variable like below. Created stage variables for all the first nine rows and sending it to a seperate file....but what should i mention after else condition, i just dont want to read the row if it is not the 1st one ? Iam doing this in sequential mode.
TRANSFORMER
DERIVATION STAGE VARIABLE
IF @INROWNUM=1 then LkFrm_Src_Seq_Inserts.column1 else ? col1
IF @INROWNUM=2 then LkFrm_Src_Seq_Inserts.column1 else ? col2
IF @INROWNUM=3 then LkFrm_Src_Seq_Inserts.column1 else ?col3
IF @INROWNUM=4 then LkFrm_Src_Seq_Inserts.column1 else ? col4
IF @INROWNUM=5 then LkFrm_Src_Seq_Inserts.column1 else ? col5
IF @INROWNUM=6 then LkFrm_Src_Seq_Inserts.column1 else ? col6
IF @INROWNUM=7 then LkFrm_Src_Seq_Inserts.column1 else ? col7
IF @INROWNUM=8 then LkFrm_Src_Seq_Inserts.column1 else ? col8
IF @INROWNUM=9 then LkFrm_Src_Seq_Inserts.column1 else ? col9
Hi Ray
I tried using @INROWNUM in stage variable like below. Created stage variables for all the first nine rows....but what should i mention after else condition, i just dont want to read the row if it is not the 1st one ? Iam doing this in sequential mode.
TRANSFORMER
DERIVATION STAGE VARIABLE
IF @INROWNUM=1 then LkFrm_Src_Seq_Inserts.column1 else ? col1
IF @INROWNUM=2 then LkFrm_Src_Seq_Inserts.column1 else ? col2
IF @INROWNUM=3 then LkFrm_Src_Seq_Inserts.column1 else ? col3
IF @INROWNUM=4 then LkFrm_Src_Seq_Inserts.column1 else ? col4
IF @INROWNUM=5 then LkFrm_Src_Seq_Inserts.column1 else ? col5
IF @INROWNUM=6 then LkFrm_Src_Seq_Inserts.column1 else ? col6
IF @INROWNUM=7 then LkFrm_Src_Seq_Inserts.column1 else ? col7
IF @INROWNUM=8 then LkFrm_Src_Seq_Inserts.column1 else ? col8
IF @INROWNUM=9 then LkFrm_Src_Seq_Inserts.column1 else ? col9
I tried using @INROWNUM in stage variable like below. Created stage variables for all the first nine rows....but what should i mention after else condition, i just dont want to read the row if it is not the 1st one ? Iam doing this in sequential mode.
TRANSFORMER
DERIVATION STAGE VARIABLE
IF @INROWNUM=1 then LkFrm_Src_Seq_Inserts.column1 else ? col1
IF @INROWNUM=2 then LkFrm_Src_Seq_Inserts.column1 else ? col2
IF @INROWNUM=3 then LkFrm_Src_Seq_Inserts.column1 else ? col3
IF @INROWNUM=4 then LkFrm_Src_Seq_Inserts.column1 else ? col4
IF @INROWNUM=5 then LkFrm_Src_Seq_Inserts.column1 else ? col5
IF @INROWNUM=6 then LkFrm_Src_Seq_Inserts.column1 else ? col6
IF @INROWNUM=7 then LkFrm_Src_Seq_Inserts.column1 else ? col7
IF @INROWNUM=8 then LkFrm_Src_Seq_Inserts.column1 else ? col8
IF @INROWNUM=9 then LkFrm_Src_Seq_Inserts.column1 else ? col9