DSXchange

Try using mod function. MOD(KeyMgtGetNextValue('your job name'),25000) Hi All I have one huge file with name price.txt .I need to split this file for every 25000 records.After splitting the out files will be price_timestamp.txt .So I have tried with UNIX split command .this is not meeting my require...

Hi,

I need to pick up the max value that is generated by job1, and use it in job2?

For job1 i have used KeyMgtGetNextValue('x').

for job2 can i use the KeyMgtGetMaxKey('x')?

Any ideas

Thanks in advance.

Hi Meena,

There are 25000 records opp...

Thanks.

meena wrote:Hi,
I think you can do this by using single transformer to create five sequential files and use the filter condition in transformer as DeepakCorning asked to do.

Hi,

i have to split the one file into 5 file.

ex: x

1
1
2
2
3
3
4
4
4
4

i have to split x in such a way that
1,1 goes to file 1
2,2 goes to file 2
3,3 goes to file 3
4,4,4,4 goes to file 4


Any ideas.

Thanks in advance

chulett wrote: You might want to give just a wee bit more detail... and an example.

Here are the examples

B-CDE PASS "NEED TO REPLACE B WITH XYZ"

A-HJU PASS "NEED TO REPLACE A WITH XYZ"

AHJU PASS "NEED TO REPLACE A WITH XYZ"

Thanks in Advance.

Hi,

how to replace a leading prefix with 'xyz'

Thanks in advance

Hi,


I am doing a lookup, both sorce and lookup(hash file) has matching records. but the records are not hooking up, and no data is coming from lookup.

i deleted the hash file and recreated it.

can some let me what's the prob.

Thanks in advance.

Hi Prabu,

can you explain in detail

Thanks

prabu wrote:

adams06 wrote:Hi,


How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

1)pivot stage

Hi,


How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

Hi, I need to read the extensions of file. i am using this code: if Trim(Field(DSLink.field,'.',2))[1,3] = 'xyz' Then 'X' else '' Thanks Is there always just one decimal point? Is is alright to take everything after it or just literally the first three characters? Use the FIELD function to take the ...

Hi,

I have to read the last three charecters after the decimal, how can i do this.

ex: 111-222.xyz
222-333-s2.abc
111-444_c_1.asd

Thanks & Regards

Hi DSguru, i have used the code that is mentioned, but it is not giving me the expected result The result looks like this X Y Z nO A B C 1 A B C 2 A B C1 1 A B C1 2 A B C2 1 A B C2 2 A B C3 1 i am supposed to get X Y Z nO A B C 1 A B C 1 A B C1 2 A B C1 2 A B C2 3 A B C2 3 A B C3 4 suggest me Thanks...

Hi, here is the input data: X Y Z A B C A B C A B C1 A B C1 A B C2 A B C2 A B C3 i need to generate the no For the first two records i need to generate 1 in column no For the 3rd and 4th records i need to generate 2 in column no For the 5th and 6th records i need to generate 3 in column no For the 7...

Hi Narasimha,

when i am running job in development its running fine, when moved into production i am getting this error

Thanks

narasimha wrote:Check the log of the job x to get more details

when i am running a sequence, i am getting the following error

Unhandled abort encountered in job x on server


Please let me know how to handle this error.


Thanks in Advance