DSXchange

Get a compiler. It will make your life much easier as transformer is rich in helpful transform functions.

What you are doing is correct but you need to add another step. Currently if you feed your input (the one you mentioned in your prev. post) to the above logic, your output will look like key1,key2,key3,desc, Count ------------------------- 100,200,300,er,1 100,200,300,er,2 100,200,300,er,3 111,222,3...

kduke wrote: I am starting to forget the Server stuff.

Who's going to teach us the cool stuff then ?

There must be something you are doing wrong. Do us a favour and post a few lines of your actual file with exact number of columns and post your stage variable derivations. Lets diagnose where your slipping away, shall we.

Now thats a great ending post, along with the solution. Great. It can make life easier for folks searching for similar issues in the future.

ray.wurlod wrote:

Code: Select all

Call DSX.UTILITYHASHLOOKUP(Result,"HA_REC_TYPE","2000",2)

Hmm. I didnt know a subroutine could be called like that. Thanks for the info Ray.

Type dsjob from command prompt it will give you the syntax there, provided your dsenv is executed prior to calling dsjob. You can also go to developer guide and check out the syntax there.

Excellent advice.

Did you check the embeded post in my previous reply? Vincent has given the complete code on how to get it done.

Thats a good question Kumar. So sshettar, why do you want to convert it into internal format again? Btw, there is no such thing as internal format for date or time in px world.

kduke wrote:du -s ProjectDir

Is probably a better command.

Thats the command that was'nt coming to me. Its du. Thanks Kim.

Test it out. make a copy of your DSParams file so that the original one is safe, copy the entire file and see if everything is ok. Test out a few jobs.

kumar_s wrote:StringToTimestamp().

You sure that will give a numerical representation of timestamp

I was wondering when you were going to figure that out. What trigger are you using? Still this? In Routine1's trigger I am using custom(conditional) and expression as DSJS.RUNWARN. Completely overlooked that. I guess I was more concerned with your question of using it twice rather than what you are...