Spain
4240
Singapore
3965
Australia
1220
Spain
1000
Spain
3500
Singapore
2410
Australia
5105
Mexico
2760
Data set
Data set
jane.doe@email.com
Singapore
john.doe@email.com
Australia
Lookup table of users and their geography
Lookup table of users and their geography
Capturing the User ID to manipulate the workflow output
In this workflow, we want to capture the user variable to look up the user's geography and provide data relevant to only that geography.
E.g. if the user is based in Singapore, the final output of the data should only be for Singapore
Update data set based on the user geography
Join to dataset to filter only data relevant to user's geography
Join to dataset to filter only data relevant to user's geography
Look up the user's details from MongoDB
Join to the user details from MongoDB user table
Join to the user details from MongoDB user table
Connect to the Server MongoDB user table
localhost:27018
user
44839289C3FE07BC7BA7848415A63B48AD9E8F43F73F831E2C2AB5B72C3DE042CAF7455A059C60B3137AC9F02A11E94BA6CAD90FCD99DAE66A6C4B94FAD1E32D6513DAC6B4DADFA7638C24FEFCD17F8EF1BC33B9E3C6FD86EC3C5DB39C487D3A8B1D5B64BB0C47D81AFBD58A278D1EA595453BF3C9C7E1EACA63E7B181838842AA0403C86
AlteryxGallery
users
Automatic
Specify the MongoDB credentials from the System Settings configured on your Server machine
Specify the MongoDB credentials from the System Settings configured on your Server machine
_id
Parse the user ID
Parse the user ID so it can be matched with the variable captured using the __Cloud:UserId text box
Capture the User ID
Use an Action tool to update and store the value
Update Value
6346d95cf44b6b1d9105c924
Capture UserID variable in a Text Input tool
Capture UserID variable in a Text Input tool
__cloud:UserId
Capture the MongoDB user ID using the Text Box tool when user runs the workflow
__cloud:UserId
Look up the user's geography from a look up table
Join to look up table to identify user's geography
Join to look up table to identify user's geography
Horizontal
Question
__cloud:UserId
User CloudId Prebuilt Example for Server Dynamic Workflow
NoCondition
(Always Run)
Dynamic
{{INPUT}}
6/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
Tab
Questions
Tab (1)
TextBox
__cloud:UserId
Wizard