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.
Thank you for that reply. The reason I want to use SQL is that the .yxdb is the detailed, transaction-level data. A co-worker gave me the SQL code that reads that data and creates summarized report. I don't want to have to recreate that sql logic using Alteryx formula tools. It has some CASE statements and other things.
I don't want to have to recreate that sql logic using Alteryx formula tools. It has some CASE statements and other things.
I think the response from the Community is that replicating the functionality using Alteryx tools is the way to go. I'm confident the functionality is there, and the Community is definitely here to help!
Do you have any functions/logic that seem like roadblocks?
I don't have Alteryx open, but here is a quick example I have from RStudio, in this case a CTE.
raw_cte <- sqldf("with structure (employee, id, man_id, hierarchy) as (
1 from raw
t1.hierarchy + 1
from structure t1 join raw t2
on t1.man_id = t2.id)
where man_id is not null
order by employee")