Can any one helpe me how to link Smartsheet to Alteryx using Live data connector.<\/p>","bodyRaw":"[{\"insert\":\"Hi Team.\\nCan any one helpe me how to link Smartsheet to Alteryx using Live data connector.\\n\"}]","format":"rich","dateInserted":"2020-07-23T16:04:26+00:00","insertUser":{"userID":91546,"name":"Jimmy_432","url":"https:\/\/community.smartsheet.com\/profile\/Jimmy_432","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi6FakKjDgSU7uwLKClKGoWRDPyGy4LK28DoSlqQA","dateLastActive":"2020-07-30T05:32:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/70075\/smartsheet-to-alteryx-connection","embedType":"quote","name":"SmartSheet to Alteryx Connection"}">
https://community.smartsheet.com/discussion/70075/smartsheet-to-alteryx-connection
✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
You can use Skyvia to connect Smartsheet and Alreryx. You can eitherreplicate Smartsheetdata to DWH and then set up the connection to Alteryx, or you canshareSmartsheets data as OData endpoint, if Alteryx supports it. Hope it helps.
I understand. Unfortunately, there is no other option that I see. One thing to make it easier for you to add the name is to have a helper column in the source sheet with a formula to identify duplicates. If there is a record with no duplicate (i.e., a new name added), you can get notified through a workflow and use that to add the name to your metric sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106937,"type":"question","name":"Column shifting","excerpt":"Hi There, Currently, I have set up dynamic drop down in target sheet and the rule is the column index can not change (i.e. stay index 32) However, the column is shifting (i.e. from 32 to 57) but user claims they didn't move or change the column index. Is there any way we can figure out why this happening or any where we…","snippet":"Hi There, Currently, I have set up dynamic drop down in target sheet and the rule is the column index can not change (i.e. stay index 32) However, the column is shifting (i.e.…","categoryID":321,"dateInserted":"2023-06-27T07:31:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T08:59:15+00:00","insertUserID":161133,"insertUser":{"userID":161133,"name":"Man Chui","url":"https:\/\/community.smartsheet.com\/profile\/Man%20Chui","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T09:36:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-28T09:37:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3375795628,"url":"https:\/\/community.smartsheet.com\/discussion\/106937\/column-shifting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106937\/column-shifting","format":"Rich","lastPost":{"discussionID":106937,"commentID":382758,"name":"Re: Column shifting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382758#Comment_382758","dateInserted":"2023-06-28T08:59:15+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-28T09:37:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T06:56:02+00:00","dateAnswered":"2023-06-27T12:25:56+00:00","acceptedAnswers":[{"commentID":382510,"body":"
This should be present from the activity log.<\/p>