Data Set File
Moderators: chulett, rschirm, roy
Data Set File
Hi,
Please help me and correct me if Iam wrong. I have columm like Reckey and OutRec comming from two transformers output and Iam writting to two datasets. Iam mentioning Reckey as key sqltype char and length '1' and nullable not. where for OutRec Iam not giving as key and sqltype varchar and length 80 and nullable yes. While compiling Iam getting an error as Duplicate field Identifier. I changed the columm names as OutRecI and OutRecD in datasets its working. But I want the same columm name in both datasets as OutRec . What I have to do for this .If have same columm name OutRec I can use funnel stage and I can write output to a single dataset
Thanks,
somaraju
Please help me and correct me if Iam wrong. I have columm like Reckey and OutRec comming from two transformers output and Iam writting to two datasets. Iam mentioning Reckey as key sqltype char and length '1' and nullable not. where for OutRec Iam not giving as key and sqltype varchar and length 80 and nullable yes. While compiling Iam getting an error as Duplicate field Identifier. I changed the columm names as OutRecI and OutRecD in datasets its working. But I want the same columm name in both datasets as OutRec . What I have to do for this .If have same columm name OutRec I can use funnel stage and I can write output to a single dataset
Thanks,
somaraju
somaraju
-
- Participant
- Posts: 55
- Joined: Tue Sep 20, 2005 10:58 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't think this is possible without introducing some boundary, such as a Modify stage, to rename one (or both) of the distinct names back to the single name you require is separate Data Sets. Duplication of column names on outputs of Transformers appears not to be permitted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Kumar,
Please correct me if Iam wrong. Actually my requirement is to write two datasets in to a single dataset using funnel stage. I have first daaset with Reckey and OutRecI columms and second dataset with Reckey and OutRecD columms with same metadata. I have 1 .transformer.......... Rmvdup...................dataset
columm.........key.........sql........................null
Reckey......... key......... (char1)............No
OutRecI......... notkey....varchar(80)..... yes
from transformer1 to dataset1. Iam having same metadata
2. transforme ............ rmvdup...........................dataset
columm............ Key...............sql..................null
Reckey ............ key ...............(char1)..........NO
OutRecD...........notkey............ (varchar80)....yes
from transformer2 to dataset2. Iam having same metadata.
My requirement is to have the two datasets with same columm name that is instead of OutRecI and OutRecD. I want to have OutRec in both datasets. Or is there a way other than funnel stage to write these two datasets with different columms in to a single dataset.
Thanks,
Somaraju
Please correct me if Iam wrong. Actually my requirement is to write two datasets in to a single dataset using funnel stage. I have first daaset with Reckey and OutRecI columms and second dataset with Reckey and OutRecD columms with same metadata. I have 1 .transformer.......... Rmvdup...................dataset
columm.........key.........sql........................null
Reckey......... key......... (char1)............No
OutRecI......... notkey....varchar(80)..... yes
from transformer1 to dataset1. Iam having same metadata
2. transforme ............ rmvdup...........................dataset
columm............ Key...............sql..................null
Reckey ............ key ...............(char1)..........NO
OutRecD...........notkey............ (varchar80)....yes
from transformer2 to dataset2. Iam having same metadata.
My requirement is to have the two datasets with same columm name that is instead of OutRecI and OutRecD. I want to have OutRec in both datasets. Or is there a way other than funnel stage to write these two datasets with different columms in to a single dataset.
Thanks,
Somaraju
somaraju
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
Try this:
Keep the Metadata of all output columns from both transformers the same:
OutRecI->OutRec
OutRecD->OutRec
I assume that RCP is on.
or if duplicates are to be removed from each link seperately:
Keep the Metadata of all output columns from both transformers the same:
OutRecI->OutRec
OutRecD->OutRec
I assume that RCP is on.
Code: Select all
(RCP Off)
Trans1----------|
|
Funnel-------> RemDuplicates----->Dataset
(RCP Off)|
Trans2----------|
Code: Select all
(RCP Off)
Trans1-------> RemDuplicates--------|
|
Funnel------>Dataset
(RCP Off)|
Trans2-------> RemDuplicates--------|
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
Hi Amey Vaidya,
Actually I tried uor optioin
Transformer1.............................................RmVdup1
output columm from Transform1.....Reckey,OutRecI
Transformer2................................................RmVdup2
output columm from transform2......Reckey,OutRecD
RmVdup1....(RCPOFF).................................DataSet1
output columm from RmVdup1.....Reckey,OutRec
RmVdup2.....(RCPOFF)................................DataSet2
OutPutColumm from RmVdup2.....Reckey,OutRec
But Iam getting the same error
main_program: Fatal Error: Interface component "OutRec" is not a value field.
Thanks,
Somaraju
Actually I tried uor optioin
Transformer1.............................................RmVdup1
output columm from Transform1.....Reckey,OutRecI
Transformer2................................................RmVdup2
output columm from transform2......Reckey,OutRecD
RmVdup1....(RCPOFF).................................DataSet1
output columm from RmVdup1.....Reckey,OutRec
RmVdup2.....(RCPOFF)................................DataSet2
OutPutColumm from RmVdup2.....Reckey,OutRec
But Iam getting the same error
main_program: Fatal Error: Interface component "OutRec" is not a value field.
Thanks,
Somaraju
somaraju