Make "max number of columns" a variable

Vera O

Hi All,

Is there any way to make the max number of columns value a variable?

I do not always know prior how many cases will I have so I would like to add a variable that could be for example the result of the list-count.

Many thanks!

Kind regards,

Vera

Josh Boxer

Hi Vera

You can make Workflow step values variable using Workflow parameters:

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-a-workflow/#workflowparameters

https://community.experianaperture.io/discussion/795/setting-up-a-parameter-to-work-across-multiple-workflows

Vera O

Hi Josh,

yes, I know how to use the parameter, but there I just have 2 options (if I'm not mistaken): adding a default value or manually entering the value of the parameter.

But I would like to calculate the value of the parameter in the workflow because I do not know the value in advance - meaning the value of the parameter should be also variable.

Hope my question makes sense!

Thanks!

Kind regards,

Vera

Josh Boxer

https://community.experianaperture.io/discussion/795/setting-up-a-parameter-to-work-across-multiple-workflows

There is Function 'List Count', that should be useful

Vera O

Hi Josh,

I think I could not make my point 😅

Yes, I'm actually using List-Count function in the workflow.

So let's say the result is 4 of the List-Count. How can I add "4" to the Text in columns "max number of rows"?

Let's say in another case, when the source data has been changed in the same workflow, the List-Count result will be 6.

That's why I wanted to add it as a variable because the source data is changing and the max number of rows should also change accordingly.

Thanks!

Kind regards,

Vera