community
cancel
Showing results for 
Search instead for 
Did you mean: 

Bengaluru, IN

Welcome to the Bengaluru, India Alteryx User Group! Please join us in sharing experiences, best practices, and knowledge.

User Group Leaders:

Yugandhar Muley (Yug) Subrat Das Jerrin Thomas Manjunath Shastry

Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted

Creating and altering sql indexes in alteryx workflow.

Asteroid

Hi all,

 

How can I create and alter Indexes in Alteryx for the below SQL code which should automatically reflect in SQL Server database? 

 

ALTER INDEX ALL ON [AdventureWorks].[dbo].[Persons] 

  REBUILD; 

 

thanks in advance.

 

Best regards,

Sreenivasa Teja.

1 REPLY 1
Meteor

I am not sure if there any other method, as there is no in-DB sort tool i once used Sample In-DB tool with 100% sample output with Sample records based on order selected and selected the fields need to be indexed and overwrite the existing table or creating new table using Write data In-DB tool.

 

clipboard_image_0.png