Make "max number of columns" a variable
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
Tagged:
0
Answers
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
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
There is Function 'List Count', that should be useful
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