aoris
Member
Hello! I have worked on the iterator for a few hours, successfully recording data in MySQL and Google Sheets (). I have noticed that when I concatenate values that include both iterated variables and single variables, the iteration only works when the first variable that is included is iterated. Example:
Using the iterator output, if I program the workflow to concatenate order - product id - price, I get 1 row. If I concatenate product id - order - price, I get 3 rows. I get this behavior in both the Number Formatter -> Spreadsheet Formulas -> Concatenate approach and by simply inserting the variables in the MySQL input field.
Is that the expected behavior?
Thanks!
Mickael
product id | order | price |
1 | 21 | 123 |
2 | 21 | 544 |
3 | 21 | 34 |
Using the iterator output, if I program the workflow to concatenate order - product id - price, I get 1 row. If I concatenate product id - order - price, I get 3 rows. I get this behavior in both the Number Formatter -> Spreadsheet Formulas -> Concatenate approach and by simply inserting the variables in the MySQL input field.
Is that the expected behavior?
Thanks!
Mickael