Unique Column IN-DB (Oracle)

[grandepaci]

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

[AndrewSu]

@grandepaci , does the post below describe your issue as well?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-DB-Unique-with-Summarize-Group-By-n... 

Having more context will help us work towards a solution together. 

Thanks.

[apathetichell]

I second this. I use the Summarize tool both In-DB - and on Canvas in lieu of the Unique Tool...