Append to Variable Issue?

I noticed if I had an Append to Variable action under an ADO Dataset Iterator that some of the lines I was appending to the var were being missed... The values were valid and I could watch the append happening "sucessfully", but the values were'nt being appended.

After a bit of investigation it seems the I was appending had emedded variables (which is fine), the append didn't seem to work correctly when that embedded variable value had a % sign in it, it just skipped if entirely - pretty sure thats a bug...

TJ

Hi TJ,

When you’re referencing the variable in the Append to Variable action you’ll need to use the %!variable_name% syntax which will stop the variable expansion engine trying to recursively expand the variable.

Regards,
Paul.

Yup, thats what I ended up doing, that being said, the behaviour of the append action isn't what I would have expected - is this a bug or will this continue to be the way the action works?

TJ

Hi TJ,

This is by-design, not a bug.

Regards,
Paul.