Dear Alteryx Community,
Im using IN-DB Tools to save Tables with unique Key Values into another table.
These uniqe Key Values are getting combined with ID´s in my query, wich results in same Key-Values with diffrent ID´s.
The Unique tool could then filter my unique "Key Values", but since we work with big data sets, we cant afford streaming in the data into Alteryx. I try to achive a solution with IN-DB Tools only. Im Using Oracle DB.
The Query would look like that:
select
List1.Key_Value,
List1.Time,
List2.ID
FROM
List1,
List2
WHERE
List1.Key_Value = List2.Key_Value
AND
LIST1.Time = List2.Timestamp
Things that didnt work yet:
1. Putting the "unique" command after the select only allows unique rows instead of unique Key Values
2. "Summarize IN-DB" doesnt work either. When Grouping by All Columns, i get the same results as before.
3. I also tried only Selecting the Unique Key Values with "Summarize IN-DB" and then joining them with the query.
But since the "Join IN-DB" doesnt allow much configuration, i couldnt get that to work.
Does anyone have another Idea to get an IN-DB Unique?
Thanks in advance
Gabriel
