• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Iterator: concatenation only works when the first variable is an iteration.

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:

product idorderprice
121123
221544
32134

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
 
Top