Skip to main content
Question

How to use dynamic parameter variable to store select query output?

  • September 22, 2021
  • 1 reply
  • 22 views

Hi All,

 

In celonis transformation I would like to use Dynamic parameter to store the select query output and the same parameter i need to use in upcoming queries for further processing.

 

Could you please help me with option for the same?

 

Thanks in Advance.

1 reply

gabriel.okaba11
Celonaut
Forum|alt.badge.img+2
  • Celonaut
  • 229 replies
  • November 22, 2021

Hi Nanthinidevi,

 

Parameters allow you to define reusable pieces of information on data pool level to be reused in specific tasks using their parameters. Within the data pool, go to Data Pool Parameters on the left side and select dynamic.

You can use one of the following operations to get a dynamic value to be reused within the data jobs

FIND_MAX

FIND_MIN

LIST