DSXchange

Trim function doesn't work in conjuction with IsNull.

Try StripWhiteSpace(%string%), if you want to just strip off spaces in the string.

Sort column / columns on which you want to identify duplicates Call Transformation Routine RowProcCompareWithPreviousValue Or Create 3 Stage Vaibles, need to be in order. StageVariable1 --> svCurr --> <Column Names> StageVariable2 --> svUni -->If svPrev = svCurr Then 'D' Else 'U' StageVariable3 --> ...

Hi Amey, your script is good. Below is the result of your script, but this is not what I was looking for. Status code = 0 Status code = 0 Transformer_3 Status code = 0 Status code = 0 0 0 0 0 49 49 49 49 49 I am looking for JOB_NAME JOB_START_TIME JOB_END_TIME STAGE_NAME LINK_NAME ROW_COUNT JOB_STAT...

Hi Amey
Yeah, please post the detail script and let me see if I can make it happen with your script.

Thanks
SriMitta

Hi Ray,

To get Job Name I tried Field() function Field(DSLink2.JOBS,':',2) in Derivation.

It's returning Job Name & anything after ':'.

Any how to use system variable @FM to read required data.

Thanks
SriMitta

here what I exactly what you needed from it

is a COPY/PASTE from Craig's response

Short answer: as one long varchar field. Long answer would depend on exactly what you needed from it.

Sorry about that.
SriMitta

Sorry earlier reply was not complete, here what I exactly what you needed from it.

JOB_NAME
JOB_START_TIME
JOB_END_TIME
STAGE_NAME
LINK_NAME
ROW_COUNT
JOB_STATUS

Thanks
SriMitta

I know what you mean to say. Read as a single column with max column width. This is what I need from job report, any idea how to get this info. STATUS REPORT FOR JOB: Audit_Job Job start time=2008-03-17 18:56:23 Job end time=2008-03-17 18:56:26 Job status=1 (Finished OK) Stage: Copy_of_Sequential_Fi...

Without file format option below is the Report generated by job. ************************************************** STATUS REPORT FOR JOB: Audit_Job Generated: 2008-03-17 18:56:26 Job start time=2008-03-17 18:56:23 Job end time=2008-03-17 18:56:26 Job elapsed time=00:00:03 Job status=1 (Finished OK)...

I tried to run job with format option in DSJobRport as 1;/home/srmt002,
job created a job detail text file.

And also I ran job without file option, job returned below warning.
<Job Name>..AfterJob (DoJobReport): Failed to open directory


Thanks
SriMitta

If look at Performance Stastics in the job & record count in the file are same, but I don't find correct row count in XML created by DSJobReport in After-job Subroutine.

Plese let me know if I am missing any details, for better help.

Thanks
SriMitta

Using DSJobRport in After-job subroutine.

Thanks
SriMitta

Yes, Columns need to in same order.

INPUT 1 - COL1 COL2 COL3 (3 cols)
INPUT 2 - COL1 COL2 COL3 (3 cols)

OUTPUT COL1 COL2 COL3 (3 cols)

Check APT_NO_JOBMON in environment variables under Reporting

This supposed to be False.

Thanks Ray for the reply. For same JOB_NAME, STAGE_NAME & LINK_NAME the ROW_COUNT is different and count on either of them are true. LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 5 LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 467 True count is supposed to be like t...