I have a question regarding process automation: I need to get the max. value of one column and therefore use the "Query Data Model" node. After that I want to add a new row with exactly this max value. Actually, the "Write Data to Table" node would need an int value then but the "Query Data Model" only gives me a list. How can I convvert this value?
Question
I have a question regarding process automation: I need to convert a list to an int value (see details).
Hello Mara.
Try to apply a row limit to 1 and sort by DESC.
On some occasions, I used the toInt() to force as integer. Try it as well.
Thank you.
Here you can find documentation on how to use TO_INT
https://confluence.celonis.com/display/PQLdevelopment/TO_INT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.