DSXchange

Thanks for replying.
Actaully, it is fixed that there will be no A type records after B type . But the character "B" can come anywhere in data. If "B" comes anywhere within data then use of Index function will fail as it is not actually the start identifier of B type records.

Thanks for the suggession... I am not sure how many output link i would require and also the number of recors within the same row is not fixed??? Is there any other way to achieve it??
Thanks for you help!!

Hi, We have a requirement where we are getting a fixed width file of length 60. The source system is sending the data in below format A-----A-----B---------B---------B---------B---------@@@@@@@@ A-----A-----A-----A-----B---------B---------@@@@@@@@@@@@@@@@ A-----A-----A-----A-----A-----A-----A-----A-...

Hi ,
I have a reuirement to convert the row data into column based on key.

The data will be like
1|A
1|B
1|C
2|X
3|Y
3|Z

Output should be like :
1|A,B,C
2|X
3|Y,Z

Pls Help!!!

Hi All, I have one requirement to convert the data coming in multiple rows to one row. I will try to explain the scenario with an example. Data is like Col A ==== 1000 2000 4570 2345 The requirement is to get the data like Col A ==== 1000,2000,4570,2345 Source is Oracle and Target is File. Thanks fo...

YES!!! U DO HAVE...
USE SAP R/3 PACK

Use a remove duplicate stage in ur reference link..I t will resolve the issue

If you have null in the target record..It will be rejected from the file

If you have null in the target record..It will be rejected from the file

Try this
Lets suppose column A data is of length 10.
Take a subsrting of full length i.e. A[1,10]
Now trim it
Trim(A[1,10]) will remove all the spaces..

Read the source metadata as varchar the use String to Date format in the transformer

You have defined your source metadata as Char[8] ,but i can see the data is only of 7 digits..is the last digit a null or space..if it is... then you will not be able to convert it into decimal...
Change the source metadata to varchar and then try..

I am not sure how will you see your job design in production if you want only executables... Job design will not make your export heavy..always practice to have executables along with design

Use a lookup stage and set the property to reject ...Capture the rejected record and use it ....

After generating the file ..use after job subroutine or Unix shell script to rename the file