DSXchange

Also note I changed your Job Type from Parallel to Server as there is no Folder stage on the PX side. I also deleted your duplicate post in the PX forum, please don't post the same question multiple times.

What happens when you set 'Preserve' to yes?

As noted, simply saying the data "is not what I want" doesn't really help us help you.

[split from this topic]

Let's get you into your own topic. Please edit your post to let us know your particulars, version and O/S. And let's start off by posting your job design and examples of your input & output.

Why not simply check the help as noted or the included documentation?

Unfortunately, I can't as I have nothing to check against. Worst case, you might want to try exporting the entire 'Ascential' branch, remove it and then see what happens after it is replaced. Did you try the 'regedit' search here? Some people have posted specific registry key(s) but from what I reca...

You could probably turn up what you are looking for by searching for "regedit" but basically you would use it to remove the entries for the Designer. Next time you launch the client, it will restore them with their default settings.

You might want to check with support. Sometimes they plug holes and fix things that people didn't know were broken and relied upon. And sometimes they break things.

Thought that might be next... heven't there been posts in the past indicating that (for whatever reason) some of these functions just don't seem to like datasets?

The file is being created in a Server job, the problem comes in when a Parallel job tries to read it.

You'll get the Top 5 sums per node unless you throttle things down to sequential execution, hence my suggestion.

Please don't post the same question more than once. I'm locking this one.

Add FMT 'xxL' after the column name, replacing xx with the output size you want to use. So, for example to make it a 30 character string, use SELECT NAME FMT '30L' FROM etc.

That's why I said "for now". Long term solution is to fix your PATH environment variable as noted earlier so it includes the proper path to it.

Hopefully, nothing new has shown up between the time you processed them and you ran this.