DSXchange

Maybe the o/p is saying that input is char(10) of which it has 7 non-blank chars and 3 blank chars (which is to be replaced by 'AAA')

Something like

What if you add only 1 parameter in the stage and try it ?

Maybe a parameter is not declared or word differently.

How do you intend to invoke the routine in the first place ?

Add an execute command stage in sequencer and use its result in user variables.

What have you tried so far ?

You can infact do it by descending date - if you are really really adamant. You can send the years with corresponding previous year values followed by a lookup of the same in main stream. Steps will be 1.) Send currentKey, currentYear, previousKey and previousYear values in another link (other than ...

Ray,

The o/p expects atleast one row from "source" and not "reference".

Few questions for you to answer 1.) Did you change the hashed file metadata after its creation ? 2.) What is the datatype (including length) of the hashed file key column ? 3.) What is the datatype (including length) of source column using which you are doing the lookup ? Copy one value from key col...

All I was trying to convey is your solution is what I had in my mind. You may have to add 1 more stage variable.

That was what we were mentioning.

From me - descending => reverse order. Not descending by date.

Hope this clarifies.

balu536 wrote: Please clarify whether this logic can be achieved with the stage variables in Transformer.

I thought that is what you wanted.

Anyhow, did you give it a try? Do you have the pseudocode of what you want ?

Sort IS required as we need the data by descending on your key(s).

Hint: You will need 4 stage variables.

Think about it and write a pseudocode. I will leave it to your thought process.

You can call your job from a sequencer.

After the job, check the file whether there are any rows with execute and condition stages.

Depending on the result, branch to your required actions.

I assume you can search and find the stages required.

Sort it by key descending and use stage variables.

Can you export all jobs from folders other than the empty folder ?