Change data from source file to target?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 21, 2011 2:01 pm

Or use pxEreplace() function, documented on DSXchange.

chulett · Post by **chulett** » Fri Jan 21, 2011 2:27 pm

Copy/paste characterset issue. Replace the "-" with one typed on your keyboard. And there's no need for a stage variable to do this.

chulett · Post by **chulett** » Fri Jan 21, 2011 3:39 pm

Assuming 'Tax_Rate_area' is the correct field, check for spaces or other vaules that would cause the check to fail. Perhaps a trim is in order?

chulett · Post by **chulett** » Fri Jan 21, 2011 9:12 pm

Already addressed that issue. Type it in yourself, do not copy/paste from the post that suggested it... as that "dash" and your dash are different characters.

marpadga18 · Post by **marpadga18** » Fri Jan 21, 2011 10:15 pm

chulett wrote:Already addressed that issue. Type it in yourself, do not copy/paste from the post that suggested it... as that "dash" and your dash are different characters. ...

hi craig

I got it u r really genius thanks for quick reply and help!!!!

Ravi.K · Post by **Ravi.K** » Sat Jan 22, 2011 1:16 am

chulett wrote:Copy/paste characterset issue. Replace the "-" with one typed on your keyboard. And there's no need for a stage variable to do this. ...

I agree with you to write in column derivation instead of Stage variable. I was habituated to write stage variables for new derivations.

Please suggest any performance implications is there using stage variables.

Thanks.

chulett · Post by **chulett** » Sat Jan 22, 2011 9:35 am

Any 'performance implications' should be for the positive if they are leveraged properly. There isn't in this case, either way, it just doesn't show a good understanding of how to leverage them. Typical use would be for derivations that you need to leverage multiple times in the stage - derive it once in the stage variable, reference it multiple times.

There are other uses, of course, for example self-documenting a complex derivation either by judicious naming of stage variables and/or breaking the derivation up into bite-sized (and well named) chunks that make more sense when put back together.

And of course, a poorly written derivation - be it in a stage variable or not - can certainly have performance implications. And not of the good kind.

Ravi.K · Post by **Ravi.K** » Sat Jan 22, 2011 11:32 am

Thanks Craig for the detailed explanation.