Update a specific number of rows

0

Hi,

That's what this action is for,
you should set which column returns unique values and it will be the key for changes in other columns, preferably det_id, if the list already contains data.

Regards

Hi,

depending on the complexity it may be easier to use the foreach operator. In the for each operator you can use the 'Change value of single field' action to modify a column/cell of the current row.

Best regards,
Daniel

Hi Karol, thanks for your answer, I solved it exactly this way

Hi Daniel but if I use foreach operator then it will update me all rows, i need to update rows just in specified number which are defined in field "Nr fields to update"

Hi Marcin,

inside the for each you can make use of the if or else switch operator. You can use them to define the condition when a row/field should be updated.

I only mentioned it, because some people may struggle with the SQL statement and this would be an alternative.

Best regards,
Daniel

Yes, you're right, I hadn't even considered that. Thank's