DSXchange

Background... I have a job that has many DRS stages within it. Each of the DRS stages uses environment variables to obtain Database Type, Connection Name etc. I need to change each of the variable names to conform with my environment variables - which are (unfortunately) different to the ones contai...

OK - changed the initial selection to use user-defined SQL to select the net balance from the two tables as suggested by Kenneth. This achieves the exact same result but performs alot better. Using user defined SQL just didn't feel like the purist way to do things - but I guess at the end of the day...

I have two tables with the same keys and I would like to calculate the cumulative difference between them. From table1 I select the YTD balance up until the current month, from table2 I select the YTD balance up until the previous month. The difference is what I post into the current period in my ta...

Many Thanks Kenneth

I removed the line below from the routine and it now works as I want it to:
"Common /SDKStringDecode/ Initialized, ValueArray, LookupArray"

Thanks again
Tim

Hi. I am having a problem with a server job that uses the StringDecode routine several times in a single stage in Stage Variable derivations. The data set I am working with has a transaction type field and 5 amount columns that represent various types of calculations such as sale price, discount, co...

Hi there Just thought I would add a small solution to something that caught me out with a sort stage feeding a aggregator... I found that case sensitivity on the input data caused an issue. I specified a "FIELD1 A, FIELD2 A" type sort on my Sort stage but as FIELD1 contained both upper and...