Page 1 of 1
Hashed file and routine
Posted: Tue May 24, 2005 10:24 am
by snassimr
Hi !
I try to do some things :
in transformer output side of it i have a derived field that must use value from hashed file
<<target column>> = @inRowcount + <<Link to hashed file>>.Count
But I want to read <<Link to hashed file>>.Count before and use it for
derivation . I cant to set it as a stage variable !!!
So help me , please
Posted: Tue May 24, 2005 10:25 am
by Sainath.Srinivasan
Can you tell us what issue you are facing when you attempt to do it.
Posted: Tue May 24, 2005 12:32 pm
by snassimr
The value from hashfile is null and all derivation set to null.
May be there is another way to bring the value of "count" to derivation ?
Posted: Tue May 24, 2005 1:00 pm
by dsdesigner
If you are getting a null then maybe, you should set it to 0 and add it to the @INROWNUM ??
Thanks
Posted: Wed May 25, 2005 12:45 am
by snassimr
But I want to extract value from hash and it isnt 0 there
Posted: Wed May 25, 2005 4:59 am
by Sainath.Srinivasan
Try to view the data and check whether the key value and its format matches.
Posted: Wed May 25, 2005 5:23 am
by dsxdev
are you trying to create some kind of sequence by getting a count from the hash file and add the row number.
in such how arre you getting the count from the hash file to transformer.
Check the from hash file as soon as you read it by using a peek stage.
If you are getting avalid value then check the data type and nullability. of this column in all stages.
Posted: Wed May 25, 2005 6:56 am
by chulett
dsxdev wrote:Check the from hash file as soon as you read it by using a peek stage.
Now you're mixing your products. Server has Hash files but no Peek stage. EE/PX is vice-versa - no Hash but does have the Peek stage.
In Server, if you are not sure for some reason what's in a hash file (and you don't feel comfortable trying to query it) you could always write a little job to source it to a flat file and then inspect the flat file.
snassimr - Other than that, there isn't nearly enough information (yet) about what you are trying to do
exactly for anyone to do anything other than flounder around and
guess to try and help you. What does your hash file look like - structure and contents? How are you setting its Key Expression in the Transformer? Why does the title of your post mention the word 'routine'?
Try to explain your problem again in more detail and we'll see what we can do to help.