DSXchange

The code is not in a single tab. You can see the flow in logic tab.

Btw, why do you intend to view / change the code?

Or use parameters to substitute when you know the name

You can achieve the same from existing operators (e.g. using 2 agg stage) or db functions.

Before building new operators you must consider how the data is to flow in and out.

You are correct. The year is mandatory.

The solution is assuming that the user knows which year they are working on. They may not be knowing the month alone. Otherwise I do not see any business purpose.

The "mod + 1" will handle that.

The function will return only one value.

I do not have Premium Membership. So can't see your posting in full.

I will find the next month (i.e. 11 + 1 = 12) and take first date minus 1.

In short and then convert the result to your required format.

By writing a NullToEmpty transformation

Or use quality stage which does exactly what you need.

Are you sure that your job will finish within the 30 mins? What if it over-runs?

In the sequencer, you can make the job sleep for "30 - x" seconds, where x is computed using the job start and finish time.

Alternatively you can make your input read a pipe making it realtime load.

Personally I will do a timing on the jobs and raise alarm of anything behind schedule. For your requirement.... Split your seq start to call a sleep activity until 7:30 and join it to output link from last stage into a sequence stage. Output link of seq stage pointing to kill anything still running....

Split the phone into two columns and pass through aggregator to max

In simple terms, create the output with all possible columns and map the source.

Did you try it outside ds?