DSXchange

Set a stage variable to look for and hold that value, and then use it as a constraint on the output.

Hi Ray, I actually had that thought originally - but then upon re-reading (re-interpreting) the requirement, I thought that all the records which have a multiple return are to be rejected. Hence the count rather than the row number.

Either or depending on requirement I guess.

I would suggest a sparse lookup with a custom sql to select exactly what you want.

Seriously? What Craig meant, was that if your target DB has the field set as DATE then when you look at the value and see 09-12-32, that is just the representation of the date in which ever tool you are using. If you would like to see it represented otherwise, either change the settings in the view ...

If I understand there are a number of ways to achieve this. If you want to reject records where it would return multiple rows, you could amend your Oracle lookup select statement to include a count of the key value attached to each record. Something like "select key_value, count(*) over(partiti...

1- I need to include the 'Line' column in my output as shown in my example 2- The input file doesn't contain a fixed number of columns, i mean it could be three columns or more! :S Ok you will need to do the following: 1. Have a stage variable which determines the number of columns that you have. 2...

Or to remove the if then else from the loop variable, you could have 2 stage variables, sv1: containing the input header names - ie a literal string 'Line1|Line2|Line3' sv2: containing the row input values (as suggested by bhasds) You can then replace the loop variable with lv1: sv1['|',@ITERATION,1...

I suggested that IsValid had an issue, mainly because of your original post which suggested that it was the TrimLeadingTrailing giving the incorrect result, when actually your incorrect result was because the IsValid determined that the string '0123 abc' was a valid decimal and thus created an outpu...

Well you could try the NUM() function in conjunction with IsValid(). I am pretty sure NUM() will return true for 0123 and 0123.01 or 123.456, but false for 0123 abc. Also I am pretty sure that the isvalid test won't actually test whether the input string has the relevant precision rather that it can...

I would suggest using the Num() or Alpha() functions to find those values which contain only numbers or alpha characters.

Its actually the IsValid test that is not working. If you were to pass your input un trimmed into the IsValid test you would probably find that it returns TRUE. TrimleadingTrailing is used to remove space from the beginning and end of fields and leave multiple spaces in the middle of a string if the...

arpitchopra wrote:I have a feeling that this is because of the Trim function (which sees the space and discards everything after that space).

Did you try outputting the return value of the trim function to see what was actually output?

Well the reason for the error is because there an error converting from a string to a date somewhere in your job. If you want to see where in the job the problem is you can add the environment variable APT_DISABLE_COMBINATION and set to true. Did the job abort as part of a sequence? If so then an er...

Interesting ...

Does the IsNull() function work correctly?

At a guess - Do you have the same column name in all the files?

What is your left link? If multiple inputs have the same column names only the column from the left link is available for mapping.