Setting Variable from row in csv file

More
4 years 5 months ago #21796 by admin
Do not forget to reset variables back otherwise you will have issues sending emails

Attachment package.png not found


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21797 by admin
FYI

We have created a very simple tutorial which we hope you will find useful

www.etl-tools.com/automation/0024-performing-mail-merge.html

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #21798 by sampelje
Mike, your create sql table script is actually a copy of the get variables script

So maybe this has been my problem - how/where is id defined and what type of field is it?
Attachments:
Last edit: 4 years 5 months ago by sampelje.

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21800 by admin
>>> Mike, your create sql table script is actually a copy of the get variables script

Thank you for letting us know we have fixed the problem

>>> So maybe this has been my problem - how/where is id defined and what type of field is it?
Sorry, I am confused which problem are you talking about?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21801 by sampelje
I mean, when I build your example it works well.

as I try to implement the objects in my code, I get the error below and cannot seem to isolate why? I build the table using your scripts, so i just am not sure what i am missing
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21802 by admin
Have a look at loop variables tab from our example.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save