Unpivoting with dynamic columns

[Schmali93]

Hi together,

I have the following question:

Is it possible, to use dynamic columns within the unpivoting node?

For example, I have the following columns as value columns:

This columns can be different, depending on the input data.

I’ve seen the option to use regular expressions. Is this the solution for this issue?

Thank you in advance.

Best regards,

Andreas

[Daniel_Weikert]

As far as I know you could use variables as “temp names” do the transformation and then rename the table with the original values. I thought I have seen this in a workflow.
BR

[morpheus]

Hi @Schmali93,
if i remember correct this can be done with the node settings enforce inclution or enforce exclution. Which are below the including and excluding list boxes.

BR

[Schmali93]

Hi together,

thank you all for your feedback.

I’ve solved this issue with a wildcard now (Q*), as the column will always start with a Q.

It works for the moment.

Best regards,

Andreas