Compare various combinations with ranges

[danial_j]

Hi all,

I am struggling with a problem and don't know from where to start. I have two tables, one has the combinations that goes along till all the 3 possible digit combinations. And another table where I have different ranges. The idea is to find out which combinations (from table 1) are missing from ranges in table 2. 

For example, in below tables the combination "122" from table 1 is missing in table 2 (Range1, Range2, Range3 combined). But a combination of "121" exist in Row 5 (of Table 2), "111" exist in Row 8 and "135" exist in Row 9.

In the end, the target is to get the list of all missing combinations in table 2. Here are both tables and for simplicity not all the possible combinations are given in Table 1:

Table 1

1 1 1 1 1 2 1 1 3 1 1 4 1 1 5 1 2 1 1 2 2 1 2 3 1 2 4 1 2 5 1 3 1 1 3 2 1 3 3 1 3 4 1 3 5

 Table 2:

Index	Range1	Range2	Range3
1	5	5	5
2	3-4	3-4	3-4
3	3-5	1-2	3-5
4	3-5	3-5	1-2
5	1-2	2	1
6	1	4-5	4-5
7	2	1-2	1-2
8	1	1	1
9	1	3	3-5

Could anyone help?

[atcodedog05]

Hi @danial_j 

Here is a workflow for the task.

Output:

Workflow:

Split the value append it with the range check weather the value exists. Remove the existing Value from all the values to get non existing values.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[danial_j]

Thank you for your response @atcodedog05 but the workflow you attached looks different than the screen shot..

[PhilipMannering · Accepted solution]

Hi @danial_j 

Please see attached a workflow that finds missing combinations from Table 2.

Thanks,

Philip

[atcodedog05 · Accepted solution]

Hi @danial_j 

Honestly very sorry i have updated the workflow.

[danial_j]

Thank you so much @PhilipMannering and @atcodedog05. Your approaches worked perfectly 🙂

[atcodedog05]

Happy to help 🙂 @danial_j 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂