Pulldata question

Let me say that I love this function but have been seeking a way to extend
its use........

as an example is there any way to group the pulldata functions?

such as

pulldata(contains : this) and pulldata(matches : that)

i need to select from my csv file where rows contain values in one column
which also match the distinct value in another column

quick search('domaindetails','contains' , 'desc_txt', ../searchtext) and
search('domaindetails','matches','CS','YES')

needless to say it did not like it.........

any ideas?

John,

Glad that you have found the function helpful. Though it's maybe not ideal,
you can generally work around these kinds of needs by simply adding columns
to your dataset as necessary. For example, a column that concatenates two
separate IDs might look like this:

ID1-ID2

And then you can easily use concat() within your pulldata() call to match
values in that column. (I suggest a hyphen between values in case the IDs
are variable-length numbers: without a separator, 111 could be 1 and 11 or
it could be 11 and 1 -- whereas 1-11 is unambiguous.)

Hopefully it's easy to add a column to your pre-loaded data so that you can
get past this need without too much difficulty. Extending pulldata() would
also make sense, but users have tended to be able to work around its
limitations easily enough that it hasn't bubbled up in priority.

Best,

Chris

ยทยทยท --- Christopher Robert Dobility, Inc. (SurveyCTO) http://www.surveycto.com/ http://blog.surveycto.com/

On Wed, Jul 15, 2015 at 8:19 AM John Harper john.harper@grableservices.com wrote:

Let me say that I love this function but have been seeking a way to extend
its use........

as an example is there any way to group the pulldata functions?

such as

pulldata(contains : this) and pulldata(matches : that)

i need to select from my csv file where rows contain values in one column
which also match the distinct value in another column

quick search('domaindetails','contains' , 'desc_txt', ../searchtext) and
search('domaindetails','matches','CS','YES')

needless to say it did not like it.........

any ideas?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.