DSXchange

heh, i guess i'm too weak, eh? Couldn't resist not replying.

This can also be done in a routine where the routine returns a string that includes line feeds based on the number of days. The output of your transformer needs to only have 1 column and writes to a sequential file tho. I believe the custom stage would be better performancewise.

You really shouldn't set your topic to "urgent" cuz everyone's issue is urgent in their own eyes. Your topic should be set to a brief discription of your problem. Saying that your problem is "urgent" will not make the users answer your questions any sooner. Please realize that mo...

I'm not sure what your data volume is, but if there aren't many records, you could read the data as one big column. In our Sequential File Stage under Stage tab. There is a Line Termination selection. Select "None" and read all lines into 1 column. In your transformer you can use the conve...

oops my bad ray, i missed that. Thank you for the correction

Try date_from_string[%dd-%mm-%yyyy](input column)

You could use a Remove Duplicates stage and set it to retain the last row.

I don't have access to EE atm but I do believe that link sort can also be used to remove duplicates if you enable unique and stable sort.

Thats fine..My problem is, can a routine return more than one value. :idea: Eg: I am getting a string, Hi,How,Do,You,Do So in the string i have to extract the strings dilimited with commas.i.e, Hi How Do You Do I have to pass these values to my next Jobactivity as parameter.. :arrow: Can you provid...

I've had a similar problem with a build-op stage. When I click on the "generate" button, it would just close the window without reporting anything. I noticed that the build-op stage was "read only", so I had to contact support and they removed the "read only" tag and I ...

narayana_382 wrote:hi saravan,

kindly tell me what does D2-YMD[422]),"D2-DMY[224] this part of the IConv function exactly... does??

naraine.

YMD corresponds to year/month/day....the [422] indicates a format like YYYY-MM-DD

DMY[224] ---> DD-MM-YYYY

yes it can, but I dont think your job will run in parallel in a basic transformer. It does become a bottleneck of a parallel job from what i hear.

Hi I was wondering if there would be an error if I enter Feb 31 as the argument for JulianDayFromDate function. Or does it automatically convert it to Feb 28/29?

Isn't a lookup stage faster? Or is the difference negligible because it is only 1 record?

From my limited experience with EE, I think you have to use an intermediate stage. Using a lookup stage would be the faster as it loads the information in memory. Use the lookupstage to merge the two outputs from the aggregators so you have a record with 2 columns. Then fire the output of your looku...

Ok I got it with the str(inputlink_field:char(13):char(10),Count):inputlink_field.
No Subroutine call, this is great!

It works perfectly, thanks again Ray for the guidance.