DSXchange

You can't do it there. I would suggest a Transformer with a stage variable that has that as the Initial Value and then leave the derivation empty. That basically makes it a 'static' value over the course of the run and you can then assign it to the column in question.

It would help to post the actual failure.

It would be helpful if you told us what you tried with regards to formatting this and what issues you had. And I would imagine OConv() could handle this but I'm not anywhere that I could look up the syntax...

Connectors are the way of the future and all of the 'legacy' stages have been deprecated.

At the end of each line or buried within data fields? For the former, read it as a DOS file.

Exactly. "Before SQL" means before any row data has been processed and "After SQL" means after all of the row data has been processed.

None of previous posts related to these topics have laid down the step-by-step flow of how to work with loops. However, the examples in the manual you linked to are surprising complete and well explained, much better than the so called 'examples' I grew up with. :wink: Have you tried building the j...

The 'any other means' you are looking for would be to purchase a Premium Membership which goes towards maintaining and supporting this site and which would allow you to see the full content of any premium posts on the site - not just from Ray but he is the Big Kahuna of our little island. It won't h...

Do you understand the 'why' of that and what the difference between the types are?

Sorry but that's not the way it works around here and if anyone does I'll just delete it. How about this? Tell us what you've tried so far and what issues you've faced. Failing that, ideas you've had on how to approach this. That rather than simply coming here and pasting in nothing more than the re...

Sorry, forgot to ask - does your state file 'stand alone' or does it support a sequence object in your target database? My understanding is that changes what is stored there and you may very well need to load all values into a stand-alone state file. I'm not certain off the top of my head, been away...

Treat it as one long variable length string rather than individual fields.

No worries, I see you've found it now.

bgs_vb wrote:id,name,address,col1
1,abc,xyz,10
1,abc,xyz,10
1,abc,xyz,10
1,abc,xyz,10
1,abc,xyz,10
2,cde,yz,2
2,cde,yz,2

So... you need to turn the '5' in the original record to a '10' for that first id?