DSXchange

Oh Ok.

The NLS is not been installed. and its not possible to install it now.

Now the work around would be DS Routines or unix script.

Is there any other way of doing it without NLS istalled, please suggest.

ray.wurlod wrote:Use the correct UniChar() function to describe the characters. ...

UniChar() function does not work in Transformer, Could you please let me know how exactly do I need to use UniChar() exactly for this particular example.

appreciate your kind support

Well let me clarify that, I was thinking of changing the parameter value at run time 1. Have two parameters a.FileName(value as "SplitedFile") b.Suffix (value as 1) And use it in the File stage where all the files should get created #File_Path/#FileName#Suffix#.txt 2. The value of the Para...

I only asked to make sure we're answering the right question, that we know everything that was behind bringing you here. Off the bat, I don't see the connection between them... but maybe that's just me. Requirement is to slpit a file into multiple files based on a fixed number of records ( That is ...

dsx999 wrote:What should happen if you have more than 4 same key values (as per your example)?

Assumption is there would not be more than 4 same key.

Thanks for the answer,
Could you please explain the logic.
Thnaks
-Dawar

manoj_23sakthi wrote:Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj

Thnaks Ray.
This is my first post so made the mistake.

I have raise it in Enterprise Edition forum.

Please answer.

Regards
Dawar

Hi All, The requirement is to split the file into multiple files based on 1.Each file should contain specific number of records or less then that and 2.All the key columns should be in single file Eg: source file : col1 col2 1 a 1 b 1 c 2 d 3 k 3 g 4 b 5 x 5 b if number of records in each o/p file s...

Hi All, The requirement is to split the file into multiple files based on 1.Each file should contain specific number of records or less then that and 2.All the key columns should be in single file Eg: source file : col1 col2 1 a 1 b 1 c 2 d 3 k 3 g 4 b 5 x 5 b if number of records in each o/p file s...