Hi all, here's a problem which I faced during my analysis, really appreciate if I could have some help on it!
I have several record IDs with codes of respective values, for example:
Record ID | Code | Values |
1 | a | 0.2 |
1 | b | 0.01 |
1 | c | 0.04 |
1 | d | 0.05 |
2 | a | 0.05 |
2 | b | 0.2 |
2 | c | 0.3 |
2 | d | 0.01 |
3 | a | 0.01 |
3 | b | 0.02 |
3 | c | 0.03 |
3 | d | 0.04 |
I want to achieve an output where Values >= 0.2 for each Record ID, and if the Record ID does not have such value present, only 1 record will appear with Values = Null(). Hence, there should not be any missing Record IDs.
Below is the sample output based on Values >= 0.2:
Record ID | Code | Values |
1 | a | 0.2 |
2 | b | 0.2 |
2 | c | 0.3 |
3 | a | Null |
How do I go about doing this? Please advice thank you!
Solved! Go to Solution.
Hi @Eug_teng ,
Here is a workflow for the task.
Input - the table provided by you
Output
Workflow
Hope this helps : )
If this helps please mark the post as solution.