DSXchange

Also note that I am assuming you meant they stop after 50 warnings rather than 50 rows. Please correct any invalid assumptions on my part.

Funny, my clients always ran theirs with a limit of 1, thousands of jobs over many years. There's no reason for a Server job to ever throw an error unless something is really wrong and it needs to stop. IMHO. :wink: Now, how are you running them? Does it matter if they are started manually from the ...

I'm sorry but by Exception 'Block' do you mean the Exception Handler stage used in a Sequence job?

Yup, double-check the basics as it will be something simple like that, I'd wager.

:cry: Damn. What a shock to open the site up at work and see Kim's mug on the home page and then realize why in the heck he is there. While we didn't get a chance to visit face to face all that much and it has been a few years since I'd last seen him, he was always a friend and a great resource... i...

That's fine as it doesn't really affect my answer, it's just one-time coding which you could grind out in all the time spent here looking for something else. And would perform just fine I would wager.

Now if you had said 240...

Thanks for posting that!

My work laptop is government issue so I have a crap-ton of restrictions on mine, all maintained and pushed down to me from somewhere else, so most of my fun stuff needs to wait until I'm not at work!

Yup, that was one of the 'other methods' I was thinking of when I mentioned there were others I could think of.

So... do it from home.

I was assuming they needed the extra pipes as they were doing what looked to me like essentially a de-dup and coalesce / shuffle back into the current structure, front to back. And yes, also assuming a relatively 'small' number of columns with a volume NOT measured in the bajillions. :wink: And to y...

There are certainly other options that are more complex but are they 'better'? Hard to say. Find something that works for you and is 'self documented' properly. So do you actually only have five columns to check or that just a made up example that is only 'like' your source? (sorry, pet peeve alert)...

Worked fine for me... what about the country drop-down doesn't work for you - does it not present you with a list? As a test I used Chrome, I.E. both old and new, Windows 7 and Windows 10 without issue.

Cool you found the issue... still don't think anything like that should cause any kind of null pointer exception. I'd still suggest reporting it if you haven't yet. Edited to add: could be wrong but seems to me that nulls in places it doesn't like could / should be handled a little more... cleanly? ...

Ah, yes... there they be.

http://publibfp.boulder.ibm.com/epubs/pdf/c1938280.pdf