Is there any way to overwrite the parameter with row values?

ray.wurlod · Post by **ray.wurlod** » Sun Jul 18, 2010 4:15 pm

Assuming your data are sorted appropriately use an Aggregator stage to specify "Last" of each group, grouped by order_id. THEN use a Folder stage.

chulett · Post by **chulett** » Sun Jul 18, 2010 4:30 pm

That's the problem, they want all records for the key to be written to the same file, not just the last one which is what they are currently getting via the Folder stage. I thought the Folder did all records automatically, so either there's a bug in their version, it has somehow been implemented incorrectly or I'm completely wrong in my recollection.

Worst case, you may need to write them all out to a single file and then split them up in some sort of scripted post process (csplit comes to mind on UNIX), that or (if you have the skillz) you could write a BASIC routine to do that. It could open the original file, read the records, name the output file based on a column name and close / reopen the output file whenever that values changes.

ICE · Post by **ICE** » Mon Jul 19, 2010 1:11 am

So, folder stage files should include all the rows for that key. Right?
If this is a bug in this 7.5 version, how about in version 8 as I have plan to upgrade our existing version to version 8.
I never have this BASIC routine but I will try it

Or do we have any way to use the FileName that I read from folder stage as my output file name in the same job???
For example:

ODBC stage ->Transformer -> Folder -> Tranasformer-> Sequential File

Sequential File name will get from Folder stage File name.

Is it possible???

Thank you so much for your time,

chulett · Post by **chulett** » Mon Jul 19, 2010 6:09 am

I believe it should, no-one has contradicted that yet but you really should be reporting / confirming this with your official support provider - both for your current version and any future versions. Horse's mouth and all that.

ICE · Post by **ICE** » Tue Jul 20, 2010 7:54 pm

Yes. Will do. Thank you for your advise.

chulett wrote:I believe it should, no-one has contradicted that yet but you really should be reporting / confirming this with your official support provider - both for your current version and any future versions. Horse's mouth and all that.

ICE · Post by **ICE** » Tue Jul 20, 2010 9:25 pm

Dear All,

My problem has been solved by writing BASIC routine function in order to write all the records for spcific order file.
Thank you so much for all of your participating, time and effort to help me

Thank u,
ICE

chulett wrote:That's the problem, they want all records for the key to be written to the same file, not just the last one which is what they are currently getting via the Folder stage. I thought the Folder did all records automatically, so either there's a bug in their version, it has somehow been implemented incorrectly or I'm completely wrong in my recollection.

Worst case, you may need to write them all out to a single file and then split them up in some sort of scripted post process (csplit comes to mind on UNIX), that or (if you have the skillz) you could write a BASIC routine to do that. It could open the original file, read the records, name the output file based on a column name and close / reopen the output file whenever that values changes.