DSXchange

You can have a before job subroutine "ExecSh" and put a sleep 5. This will ensure that the job will start and wait for 5 seconds before running the main part of the job.
Also, to run multiple instances from command line, you need to suffix the job name with dot instance name(.x)

If you are using a server job or a basic transformer then do this If (in.Col Matches "...V-0N1N..." OR in.Col Matches "...V0N1N...") then Field(EREPLACE(in.Col, "Valve", "")[INDEX(EREPLACE(in.Col, "Valve", "")...

Thats ok buddy. Glad you got it resolved. Just mark it as resolved and have a cup of tea, or coffee

How are your routine writing skills?

-local option is required if your Job needs to take environmental variables. -local might be required to pick up environment variables. Granted. I dont use environment variables. Hence cannot comment more on it. -mode NORMAl option is not required if you just want to run the job. -mode option is op...

gsym wrote:So I declare all the environment variables in the job properties>job parameters and both my start dates and end dates are specified there as environment variables.

Well if you already have them setup in the job parameters then why not read them inside the transformer.

You pass the environment variable as a job parameter.

parimi123 wrote:Did you change working directory to your project directory before executing dsjob
Poorna

I highly doubt thats required Poorna.

If the entire record is identical then you dont need to worry about which one is first or last.
If only the keys are identical and you want to retain the first one then use the aggregator method as I specified.
End of story.

Group by your key and provide FIRST as the derivation for all the rest of the columns. This will ensure that you get the first row for a duplicate key.

You can define them as environment variables in the Administrator and use $PROJDEF in their place inside your stages. This way all you need to do is change the values in the administrator and the jobs will pick up the correct value during runtime.

What about the dataset? Are all fields defined as notNull there as well?

A few major differences: -Filter stage can have any number of output links where as Switch stage is limited to a max of 128 links. -Filter stage can optionally have a reject link. Switch stage requires a reject link. -A switch stage is like the C swtich function. It goes through all the cases and if...

Feed the input to an aggregator, grouped by on your key and retaining the first value. Output this to a hashed file.

You can do this with stage variables. Use hash partition to ensure that similar keys end up in one partition. Use the stage variables to compare present row with previous row and a increment another stage variable which will be used as your counter. Reset it back if there is a change. You need to ta...