DSXchange

Sure.

Either way, those same functions that exist as part of the BASIC API are part of the dsjob executable from the command line.

viewtopic.php?p=368063

Okay... go ahead. Arnd has given you the solution, however the coding is all on you I'll wager. You can use dsjob for all of this, btw, if you'd rather script this than write a job.

I don't know, I got the impression that the input stream only provides the correct information for EMP 100 when there were only records for EMP 100 in the lookup data. Once more rows are introduced into the lookup source for EMP 200, the results for EMP 100 are now wrong. :? Is that what I'm reading?

So, a count of rows rather than columns. As noted, can you spell your requirements out in words for us? That will help you (and us) get to a proper solution.

Smells like a pivot with some aggregation in one column. Trivial in a Server job, btw.

The original question has been edited from what was posted last night. All examples had an "am" or "pm" at the end, source and target, hence my comment which was speicific to the target 'needed'. The poster then over-reacted and removed too much in (what I assume was) an attempt ...

Which doesn't help the Sequence job itself or anything not run under the control of a Sequence for that matter.

Looks good and any 'Key' columns will be repeated on each row. There is no distinctness to a pivot, you'd need to enforce that downstream.

Is there a question here? What are your actual source and target datatypes?

There's no such thing as "20.30am" or "16.00pm", it's either 12 hour notation with AM/PM or 24 hour notation without it. Use StringToTimestamp() and then TimestampToString() with the appropriate Time Format string for each step, one to read it into internal format as 12hour and t...

ETL Stats is in the Tips & Tricks section of Kim's site.

Do you have a specific question on the stage or need some help getting the output you are after?

There is only one Pivot stage and it only does horizontal pivots. There should also be a Help button in the stage which explains how to use the stage.

We'd need much more in the way of specifics before anyone could help, there's not much to work with when you just say the "results are weird and wrong".