my workflow is like this
I used a loop that will take a table from each page of the web,
the table from the web contains 3 columns - Name Size Price
and after I changed each variable (by splits, and more) I want to write them into a new Excel file and a sql table.
and after that I will take the next page from the web and do the same
Hey Daniel,
You can write the variables in an Excel file, by using the AC Paste to Excel.
Regarding the sql table, you can do this with a proper sql query, used in the AC Execute SQL query.
Let us know in case of any additional questions or concerns.
Kind regards,
Kryon Support Team
thanx
so the option to write a couple of variables is only one by one? with 3 paste to excel commands?
thanx again
Hi Daniel,
You can save it all in one variable, which will serve as a list (with delimiters). You can see an example on our Kryon Academy course: Using Advanced Commands (module 7: Excel).
Enjoy!
Ayelet
(1)save all tables to variable diveded bij delimiters,
(2)do a row count on the excel file (allow no empty rows)
(3)do before each excel past; set row =row+1.
So will each paste be at the end of the earlier past
(4)Paste (1) and use A:row (paste table)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.