DSXchange

I believe you are telling it the data is already sorted, not asking it to sort the data.

Never seen such a thing. Any user should show you 'processes', it's just that they may not be able to affect any of them.

Write a routine. Use Index() to check for the "/".

Field(YourColumn,"/",1,1) would get the first field from a "/" delimited string while Field(YourColumn,"/",2,1) would get the second. Divide the two results.

For the WFF stage, as noted you'd need to figure out the right date first. For a true 'wildcard' solution, I'd suggest a script.

There could be some stray characters at the end you cannot see. What happens if you try:

/dstage/appl/inbox/Misc> cat rew.Flat_Fee_LocationExclusionList.csv*

You can either copy/paste the stages from the Shared Container into the job or first add the SC to the job and then 'deconstruct' it.

Marbis, please start your own post on this subject.

It's an interface and it is what the OCI stage uses exclusively. The DRS stage can use that or ODBC to communicate with Oracle.

So... are you saying that if you switch both Cleanup Resource windows to show 'All', nothing shows up?

First off, the Index function doesn't return 'true' it returns the starting position where it found the substring and you can treat that as 'true' but it's technically not what was returned. A trick to solve that problem is to add your internal delimiter to both ends of the string and then look for ...

Nope. There is no option to rename a project, so you accomplish it by doing exactly what you did.

Yup, thank you Mr Wurlod and nope, nothing missing below logic.

What stage are you using in the PX job, Ray?

It would help if we had a clue what you are doing - sounds like it doesn't think your sorted is already sorted. If you are trying to do the Key Change thing, make sure only your "Id" field is noted as your key field. If that doesn't work out, skip the sort and just use stage variables: Var...

I already gave you the paths.