DSXchange

bhasds

Hi Devesh, Even you may try this also with a single transformer- 1.Sort the records in the descending order based on the in transformer. 2. In stage variable- If Cust_Id <> SV2 Then Cust_Id :" ": Policy:" ": System:" ": Role Else SV1 :" ": Role SV1 Cust_Id SV2...

bhasds

Hi devesh, You may try the below steps- 1.With the help of filter stage split the records into two stream. a) Having Role as 20 and 30. b) Having Role as 10 and 230. 2.Map both the link to a funnel stage . Sort the link carrying Role as 10 and 230 in decending order taking Cust_Id Policy System as k...

bhasds

Hi New_ds_man, It is a vetical pivot- 1 If col1 <> SV2 Then col3 Else SV1 :",": col3 SV1 2. col1 SV2(initialize with "") 3. In derivation of col3 take the output of SV1. 4.Use a remove duplicate stage after transformer to retain the last duplicate record in the group.

bhasds

Hi Arun, If you are getting the values of a single parameter from a file then using list loop can help you. 1. Cat the file with execute command|xargs|tr -d '\n' Eg- Output will be file1.sql abc.sql xyz.sql 2.Pass the command output to the loop using list loop. 3.Get the execute command output in a ...

bhasds

Hi aravindunni31, The below logic may be help full- If Index(InputCol,"Kolkata",1) =0 Then InputCol Else InputCol [1,Index(InputCol,"Kolkata",1)-1] :"Calcutta":InputCol [Index(InputCol,"Kolkata",1) +7, Index(InputCol, Right(InputCol,1),1)] Please correct me if...

bhasds

So what problem you are facing now to implement the logic? put this 3 jobs in job sequence.

JobA
|
|
ExecuteCommandAcitivity
|
|
JobB
|
|
JobC

And implement what I have already told in the previous post.

bhasds

You can call the parameters in the output derivation of transformer or in job properties genearl tab, go to after job subroutine, choose ExecSh and echo "#param1# #param2# #param3# etc" > pathname/paramfile

bhasds

Hi daniele, This may be possible through job sequence- 1. In after job subroutine of JobA, echo #param1# #param2# #param3# etc > paramfile. 2.In Job sequence after JobA take an execute command and cat the paramfile. 3.In JobB activity read each parameter from execute command output through field fun...

bhasds

Hi Cherry, This may be possible through loop variable in transformer stage. 1.In stage variable- Name SV1 2. In loop variable- Loop condition- @iteration<=DCount(SV1,";") Field(SV1,";",@iteration) LV1 3.In derivation map the ID directly from input and the take the output of LV1 f...

bhasds

Hi Cherukuri,

If you have the pattern no2,2012 is common for each delimited substring then you can use-

Code: Select all

Convert("no2,2012","",IPfield )

bhasds

Hi Abhik05, You may try this through transformer- step 1- take 2 stage variable- If DSLink105.col1 <> SV1 Then SV1:" ": DSLink105.col1 Else @FALSE SV1 @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 SV2 step2- In derivation constraint- Mod(SV2,3) ="0" step3- deriavtion Fie...

bhasds

The below command can be called in execute command activity in Job Sequence

Code: Select all

mailx -s "SUBJECT" -r "senders Email ID" "recepient Email IDs"

bhasds

Hi times29,

Can you please try the below -

Code: Select all

If col1 [1,3]="KS1" OR col1 [1,2]="OR" Then Trim(col1 [Index(col1,"0","1"),Len(col1)-Index(col1,"0","1")],"0","L") Else col1

I got the desired output with this.

bhasds

Hi times29,

You can try this-

Code: Select all

Trim(Field("colname"[1,3] :" " :"colname" [4, Len("colname")-3 ]," ",2),"0","L")

bhasds

Hi Pragb, To get rid of this problem you can use the tr -d '\n' command in execute command activity. For example, if you are using the command cat filename in execute command then it should be- cat filename | tr -d '\n' Now the output from the execute command should wok fine for the notification act...

Search found 78 matches