Resetting a string pipeline variable

[pmscorca]

Hi,

inside a my pipeline I've implemented some set variable activities that operate on strings. In particular I'd like to reset the value of a string pipeline variable as a blank value.

Is the correct method to use

@''

as a dynamic content?

It doesn't exist any specific espression function.

Thanks

[v-sshirivolu]

Hi @pmscorca,

In Microsoft Fabric Data Factory, string pipeline variables cannot be set to null, and there is no specific function to clear or reset a string value. Since variables are strongly typed, the only way to reset a string variable is to assign it an empty string. You can do this in a Set variable activity by entering an empty string literal ('' or "") as dynamic content. This method is intentional and is the recommended way to represent a blank string value in Fabric pipelines.

Thank you.

[pmscorca]

Hi, thanks for your reply.
Therefore I need to write

('')

or

("")

as a dynamic content, isn't it?

[v-sshirivolu]

Hi @pmscorca ,
Yes, that’s correct. Use an empty string ('' or "") in the Set variable activity to reset the string variable.