Source values in my measurements dataset '<0.006'

[manoshatzak (Manos Chatzakis)]

Hello everyone!
I’m now implementing my first ETL and I’m currently making the measurement_table. In my source dataset, I have some examination results where the value of the result is stored like this: ‘<0.006’.
How do you suggest storing this information in the value_as_number_field?

[Alonso (Alonso Carvajal)]

Verify the operator_concept_id of the MEASUREMENT table. That is applied to the value_as_number. Operators are <, ≤, =, ≥, and >.

[manoshatzak (Manos Chatzakis)]

So,you mean that in the operator_concept_id field i put the concept_id of < and in the value_as_number field i store the value 0.006. Right?

[Eduard_Korchmar]

Correct. The concept_id of less sign is 4171756.