This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a query that I would like to automate through Alteryx.
Query1: Select col1, col2 from ABC WHERE Parameter1="afsdfsdg"
Query2: Select Query1.Col2, EFG.Col3, EFG.Col4, Count(Distinct EFG.Col5) Where EFG INNER JOIN Query1 On EFG.Col4=Col1
WHERE EFG.Parameter 2="afsasdfg"
Group By Query1.Col2, EFG.Col3, EFG.Col4
Please note that metric in Query 2 is a Count Distinct and also it brings a column from Query1. Because of these two reasons I am unable to separate the query and compute the data separately as two Input data components. Also Query 2 is running on huge database tables. Doing Count distinct at the later stage might have huge performance implication.
I want to use drop down parameters to automate this thing.