DSXchange

NUL is the byte value 0 (aka 0x00, aka Char(0)). It may be being used in the file to indicate NULL (unknown value). Check with the provider of the file before arbitrarily removing it. Or it may be that 0x00 is being used to pad fields whose data type has been declared as Char. For example NUL is the...

DSJS_NOTRUNNING means that the job has been compiled but has not been run since it was most recently compiled.

Trim() will leave one white space character where there are more than one. Prefer StripWhiteSpace() or Convert() to eliminate white space characters totally. And take some time to learn which characters are considered to be white space.

Thinking a little outside the square, another possibility is to use the Data Rules stage with a data rule definition based on an in_reference_list check. Yet another possibility is to use one of the lookup table functions in a Modify stage, with a suitable default value to reflect the "not foun...

I provided you with the needed functions - please experiment with these as a learning experience.

I prefer to teach you to fish rather than to give you a fish.
If I give you a fish that's consulting, and you pay for my time.

Why/how was your pre-processing unsuccessful?

Using the server Sequential File stage is an easy solution (provided that the string is quoted).

I'd still prefer to use Director client. Disable view of folders and you can see all jobs in the project (probably make the refresh interval quite long too). Then you can take your time over selecting the correct jobs before deleting.

Don't forget to backup (export project) before deleting.

Last day of previous month is a one day (-1 day) offset from the first day of the current month. Therefore the easiest solution is to build the first day of the current month by subtracting the current day number in the month from the current date. Functions are DateFromDaysSince() and MonthDayFromD...

Shame, really.

The answer is no. It is specifically mentioned in the Deprecated Features of the New Features and Changes page for version 11.3.

In Metadata Workbench (version 8 and 9) one could view the various models used to store metadata on the Administration tab Model View choice.

Is there an equivalent in Information Governance Catalog and, if so, where?

<rant>Resist stupid requirements!</rant>

You will need to employ some kind of sorting, even if you are maintaining the sorted list in the Transformer loop.

It would be much easier to sort the source data so that your job can know the start and end points of the values that need to be interpolated.

You might also investigate the Expand stage (in the Processing group).

Am I missing something, or is this just about sorting?