DSXchange

Have to? No, you can simply 'Clear' the hashed file as well.

I guess so. Post your latest derivation.

Data format? Does the timestamp need to be converted? If not, simply cat it back on the end of the converted date.

Just like I posted. Field() can do the parsing for you here. And since your time format is different than you originally posted, you'll need to convert that as well using "MTS".

"009"

Field needs a space as the second (delimiter) argument, so " " not "". And as I posted, it's "A3" not "3A" for a three letter month name.

Right. You need to 'convert' the date portion only and you can't include that time mask in the output conversion. So split into two, convert date, stick time back on.

Close. Build a small 'test' routine in the Manager to check. Try:
Basically, split off the time and then stick it back on the converted date.

I would do all of this work in a hashed file and, after everything has been sorted out and the final version is known, then source from the hashed file and do the actual database work. Lookup up from and write to a single hashed file from the same transformer and don't cache the lookup stage. Way qu...

Or do everything at the command line. :wink: In other words, there's no need for a script and especially not two of them. Rather than send one of the fields to another file and then cat that, simply use the Execute Command stage to 'cat' the contents of the file and then pipe the results to 'cut' to...

mdbatra wrote:

chulett wrote:You are talking about CRC32, not BASIC transformers in Parallel jobs, yes? I seem to recall some of the odd issues you had with it... ...

Yes Craig, i am just asking about how to use CRC32 in a parallel job, but without using a basic transformer.

That question was actually to Kim.

Not necessarily.

Basically the same technique with a different function:

Yes, perfectly safe. They're all really just strings when you get down to it.

As I said, you'd need to ask the people that wrote the product and that ain't us. Open a case with your official support provider and let us know what they say.