Writing SQL queries in Alteryx Designer
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vishal9031
If you want to go deep, i recommend the official material on the attached pdf.
But i understand that if you already know SQL, these are some of the important things:
a)The syntax of the queries that you gonna pass using the in db components or the data input tool will be the same that you use inside your database.
b)The In db components like the filter (image 2) are just adaptations of SQL queries (filter = where). So if you are a SQL user already and dont see any value on it, you can just paste the full query inside the in db component/data input tool.
c)You can connect to the database using the normal data input (image 1) or the in db component (image 2). The main difference is that on image 1, the data that you query will be extracted imediatelly from the database, the image 2 will extract data from the db just after the Data Stream Out component.
