Help needed for a sample problem

[Eug_teng]

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!

[atcodedog05 · Accepted 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.

[atcodedog05]

Happy to help : ) @Eug_teng 

Cheers and Happy analyzing : )