DSXchange

I'd be tempted to put all those values into a sequential file and perform a lookup rather than hardcode them all into that statement.

Create a stage variable, svBreak, with the following:
Then your column derivations will be:


Col1 Col2

What criteria do you need to use to break up the string into two parts?

Do you just want to take complete words up which make up 20 characters or less into the first column, and then pass the remaining complete words into the second column?

In the Stage / Properties tab of the aggregator stage, under the 'Aggregations' category, try adding the property 'Preserve Type' to the 'Column for Calculation', and set it to 'True'. This should force the stage to output the result of the aggregation in the datatype of the input column you are agg...

Thanks for the reply Ray. I appreciate your help, but I must admit I'm still stumped. I've had a good look in both the DS_JOBS and DS_JOBOBJECTS tables, but can't find the names of any of the QS objects that I'm looking for. Also, my project folder doesn't appear to contain any 'quality' subfolders....

Can there only be one single occurence of a word to be replaced, or could you have for example:

123 OCONNELL Drive MCDONALD Road CA USA

ArndW wrote:

Code: Select all

INDEX(In.COL1,"BANANA",1)

will return 0 if the string is not found, or a numeric start position. ...

Too quick for me!

Index(COL1,'BANANA',1) will return the position of the first occurrence of the text 'BANANA' in your column, or 0 if the text can't be found.

Hi guys, I was wondering whether anybody here knows of a way to obtain a list of QualityStage objects, such as lookup tables and match specs, and their containing categories? I'm quite familiar with querying the DS_JOBS file to produce the same kind of list for DataStage jobs, but I'd love to know w...