Hi All,
From Alteryx I am connecting through SQL Server ODBC Data Source and writing data into SQL Server tables.
I have columns CREATED_BY and CREATED_DATE for each tables.
For CREATED_DATE i will use DateTimeNow() in the formula tool.
But for CREATED_BY, how can i get the user who is connecting and running the workflow to insert records in the database tables.
While using the output tool and connecting to SQL Server, I am giving the credentials to connect.
How can this user name be collected dynamically and inserted to the columns. Is it possible?
Please help me.
Thanks,
Preethi
Résolu ! Accéder à la solution.
Hi All,
Is there an automated way to get the IP ADDRESS of the machine.
Thanks,
You should be able to take advantage of environment variables to pull this in. You simply need a formula with the getenvironmentvariable() function. In the example below, I pulled in my username.
Thanks a lot. It worked.