DSXchange

bhasds

Hi additiya, You can read the entire data as a single file and in the transformer stage variable - 1. If Field(Colname,":",1)<> SV2 Then Field(Colname,":",2, Dcount(Colname,":")) Else SV1 :",":Field(Colname,":",2, Dcount(Colname,":")) SV1 F...

bhasds

TWO step1- same as ONE step2- If Trim(colname,Right(DSLink105.col1,1),"T") <> SV2 Then colname Else SV1 :" ":Right(colname,1) SV1 Trim(colname,Right(colname,1),"T") SV2 step3- Same as ONE. However, as said by Craig you can still do it through Pivot enterprise stage.

bhasds

Hi Cherukuri, If you are still looking for any logic which can be used in transformer then the below two should give you desired out put- ONE. step1-read those 5 columns in a single column in seq file stage and passs to the transformer step2-take two stage variable in transformer- If Trim(colname,Fi...

bhasds

Hi Cherukuri,

If I have understood your question, then I think the lookup stage does exactly the same thing what you want in your job.

bhasds

Hi Venkata,

If you need to pass current year and month from sequence as a parameter then you can use Oconv function in the expression grid of the Job activity.

Code: Select all

Oconv(Date(),"DYM[4,2]")

bhasds

Hi Cherukuri, you can use 3 stage variables- In stage variable- Derivation Satage Variable If col1<>SV2 And col2 <>SV3 Then SV1+1 Else SV1 SV1(initialize by 0) col1 SV2(initialize by 0) col2 SV3(initialize by 0) In output- In the third column derivation take the out put from SV1

bhasds

Hi Phanikumar,

I was able to get the desired output with-

Code: Select all

Convert(" ",",",CompactWhiteSpace(Convert(","," ","colname")))

bhasds

Hi All,

The oracle connector stage is giving following error-

OCI function OraOCIEnvNlsCreate:OCI_UTF16ID returned status -1

This post says that the permission has to be given to the client user for oracle library.

Could you please explain how to do it in Windows?

bhasds

Hi ntr,

If you are searching with the job number, then you can search with the job number in the DS_JOBS table-

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = 'job_number';

The above query can be executed in administrator command prompt.

bhasds

or

execute the command

Code: Select all

LIST DS_JOBS WITH @ID=job_name

in administrator command prompt

bhasds

Hi Srivalli_b, I have tried with the below input- vekat raJU VENKAT RAM Raju narayana Jean Claude Van Damme Field(CompactWhiteSpace(src.col1)," ",1) col1 If Dcount(CompactWhiteSpace(src.col1)," ") >2 Then Field(CompactWhiteSpace(src.col1)," ",2,Dcount(CompactWhiteSpace(...

bhasds

Hi srivalli_b, If there are multiple spaces in first name,lastname can you plese let me know how to handle this. In the above scenario the compactwhitespace function should work fine.... If Dcount(CompactWhiteSpace(Col1)," ") >2 Then Field(CompactWhiteSpace(Col1)," ",2,Dcount(Com...

bhasds

Hi Jayakannan, The desired result for the above scenario can also be achieved through transformer and funnel stage. In transformer- 1.from transformer we can take 124 links each for one satus and date. the derivation of status and date for each output link can be- Derivation Columna Name If status_1...

bhasds

Hi Halpavan2,

The below command in filter option in sequential file stage should give you the result as said by Ray-

Code: Select all

awk -F","  '{if ($2==1 || $2==2) print $0}'

bhasds

Hi Roshan, If I have understood your question correctly, you are asking- 1.How to get record count of a file through execute command? 2.How to pass the records to the loop in sequence and the count should determine the number of time the loop should run? 3. How to prevent the loop from running if th...

DSXchange

Search found 78 matches

oracle connector not working in 8.7

Reading the sequential file

execute command for readinging sequentialfile in looping