commcare
Is it possible to lookup the closest value (equal or less than) to a particular question using a Lookup Table in CommCare?
Example:
My table has values 5, 6.35, 42.8, 136. I want an input of 6 to return 5, 6.35 to return 6.35, 48 to return 42.8, and 135 to return 42.8.
The best way to do this is to save both the location_id and the location name to the case after your multiple choice question. You can find the expression to get the location name from the location_id here:
https://confluence.dimagi.com/pages/viewpage.action?pageId=38276915
Then, just display the location name in the case list rather than location_id.
The export tool can't export users, groups or organisations (locations) but you could use a mapping table to lookup the location or supervisor info based on the user_id.
You could do this by adding a Mappings sheet to your export query that contains the lookup table.
Here is an example of what your query sheet might look like:
We've defined two fields, Location and Supervisor which both reference user_id. We've also added a Mappings sheet as follows:
For each user_id value we have mapped them to the Location and the Supervisor.
When the export is run it will do the lookups the final export will contain the mapped values.
To get the data for the Mappings sheet you can use the user export and organisations (locations) export from CommCare HQ.
Best Answer
I believe you can use
<=in a filter in combination withmaxto achieve this affect.The xpath might look something like this
That will give you the maximum value less than
target_value. If what you wanted was the entire row in the table that has that value, you can then do a lookup on that value—i.e. find the row that has the value that is the maximum value less thantarget_value: