Not sure I understand what you mean, but couldn't you just use the same data source multiple times and use combinations of joins to get what you want?
Thank you for the reply. Let me try to make simple this.
There are 3 events here. For the event #1; if the value#1 is 1 (1st row) and the value#2 is 1 (2nd row), I want to filter and display only with these. If I put a filter in general in Tableau, it will display every item if value#1 is 1 and value#2 is 1. This is not what I want. For example for the event#3, the value#2 and the value#3 are 2 and I want to display this. The challenge is, the value#2 and the value#3 have the same but in different lines. If they were on the same row, AND query will work. But because of they are on the different rows AND query will return as false.
So, multiple joins are not an option for this dataset. The table will be larger than 2GB and with millions of records.
1 of 1 people found this helpful
Not sure it works for such a huge database, but based on your example file the below DOES return the result you are looking for:
I don't see a way to add the .tflx file I created for the above, but when you send me your email in a private message I can send it to you...
I appreciate your answer. I got your mail, and it worked for this sample file. Considering my data, it was needed to clean, and also more actions like you did.
Our developer chose to go with Python.