Jump to content
rudilutz

'sources NOT in set' search

Recommended Posts

I have approx 250 'sources' all of which need to be members of (at least) one of approx 15 pre-defined 'sets'. To make sure that all have been allocated to (at least) one set, I need to run a 'sources NOT in set' search to identify any that are currently NOT MEMBERS of ANY set. I know how to do a search that lists all EXISTING set members, but not how to do one that lists any 'sources' currently NOT set members. Any help would be much appreciated.

Rudi

Share this post


Link to post
Share on other sites

Hello,

 

The search function you are trying to perform is not available in NVivo, but this doesn't mean you won't be able to achieve it. The work around for this is as follow:

Firstly,

You need to create a new set then copy all your existing sets into it before exporting the set list - as an excel file via the List view > Project menu > Export > Export list.

You then export the 'All Sources' folder - as an excel file via the List view > Project menu > Export > Export list . Ensure to sort the list before exporting.

 

Combine both of the exported list in one excel file so you can to see which source file is allocated to a set and which is not.

 

I hope this was helpful.

 

Kind regards,

David

Share this post


Link to post
Share on other sites

Hi David

 

The suggested work-around works fine - thanks a lot!

 

Combine both of the exported list in one excel file so you can to see which source file is allocated to a set and which is not.

Once one has reached this point, Excel 2007 offers three options aiding the 'filtering' process:

 

- To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab

- To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab

- To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab

 

Rudi

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×