DSXchange

I wanted to do that with aggregator, is it not possible?
With transformer I included 3 stage variable , but I was not sure how to use it
in the output link so as it sums up the Sub1 Sub2 and Sub3 values on Name key column. Please help!

Hi All, I have a scenario with sequential file as input data as below: Name Sub1 Sub2 Sub3 abc 70 80 90 def 50 70 80 ghi 50 80 90 I need to sum the columns sub1+sub2+sub3 and get the value in new column 'Total' in output file as below: Name Sub1 Sub2 Sub3 Total abc 70 80 90 240 I tried using transfo...

Please tell me how to get the data in readable format as am getting the same below error while reading records from a dataset as an output to combine stage.
[() ()]
[() () ()]
[() ()]

how to correct this format?

Hi All, I am using a dataset as input to a combine record stage which is going to a dataset dile as final output. i have some identical key columns records in my input dataset for which i need to create a sub-set, because of which am using combine records stage. My input data is as below : OPTION_ID...

Hey can anyone tell me how to use hashed file stage as a lookUp stage reading records from two SQL tables through ODBC stage and writing it into sequential file. Please help.

ok. i will post my job screen capture here so that u guys can get a clear picture of what am trying to say.thanks.

Hi, I am new to this forum...don't know whether am posting to the correct link or not...am preparing a document to show the usefulness of Hashed file stage in server jobs.Below is the scenario.. I have one input ODBC enterprise stage with one table and other referential ODBC enterprise stage with an...