DSXchange

Curious if you've solved this... and if so, would you please post the resolution? Thanks.

dls wrote:My understanding is that auto-purge criteria is only considered the next time the instance runs.

No, it happens each time the job runs, regardless of instance.

That would typically be a DBA task.

Sounds like a support question to me.

You'll need an explicit conversion, I would wager. How about showing us the input and what you want the output to look like? So people can provide more targeted advice rather than something generic.

Yes, that's what RCP - Runtime Column Propagation - is all about.

Appreciate that, it will make it much easier to help you out in the future and get you to a solution faster if you help set things up for us properly. Now, make sure to come back and clarify your requirements and ask some actual questions if you need more help than what puliram has supplied so far! :)

puliram, we're really trying to discourage people from creating drive-by posts like this. I know you're trying to help but next time could you please wait for a properly expanded reply from the OP? Thanks.

:!: Sorry but you can't just drop made up input and output examples on us and then expect a fully fleshed out answer when next you stop by. Describe your requirements in words then let us know what you've tried and what specific questions you have. And real sample data is always a good idea. Then we...

Not sure how an older release could 'officially' support anything that new but that doesn't mean it wouldn't necessarily work. Probably best as a support question unless someone wanders by that has implemented those two versions.

Welcome. You need to be strict with your data types. The abs() function returns a number and numbers don't have leading zeroes. You also don't want to be doing math on a string value like '001'. So modify your function call to something more like: If A= B then Abs(1 + Number) else '001' And then wra...

Or just remove them from Excel before saving, even if they look 'empty'.

Ah... gotcha.

Done... but there's no reason it shouldn't have worked for you that I'm aware of if what you did was attempt to edit the first post. Note that it only changes what displays at the forum level, technically each reply can have its own subject and doing that won't change all of those.

Welcome!

I'm sure someone more smarter will be along to expand on this but from playing the home version of this game I would say that you would need to create a virtual table which includes a decrypted version of the column in question in order to perform the column analysis.