Extract comments with code in column for HAVING vs NOT HAVING the code (0 - 1)

[AlexandreGareau]

Is your feature request related to a problem? Please describe.
The problem is that in my field (how we do qualitative research at my organization) we only code each comments are either having the code or not. In Qualcoder if you highlight more than one segment with a code it adds up.

Describe the solution you'd like
The solution I am looking for would be to be able to extract my data with extract columns for each code. The column name would be those of the code and the value would be 0 or 1 is the comments was found to have at least one time the code. In this case, the added count would not matter. With that in hand I could perform the rest of mixed method in another environement (excel or R/Rstudio).

Describe alternatives you've considered
I have consider creating a SQL query... but I have never done that.

I have achieved an alternative by saving a report matrix

1. Select all CASES
2. Select all codes
3. Select "codes by cases" in the upper dropdown menu
4. Export the report matrix in .xlsx
5. Wrangle the data in R

Additional context

[ccbogel]

OK. I will see what I can do.
Why do you select all cases and not one or, some, or all files?

[AlexandreGareau]

I select all CASES because I want to merge (join) back the coded data with another part of my database containing many information on each participant (case).

[ccbogel]

So can I ask what field are you in? Is it law? As it will help to clarify who might want to use this feature.
Here is an example.
You can select by cases, or all cases), files or all files, codes or all codes, and have limiters by coder name or all, and by text contained in the text box.

[ccbogel]

OK try the latest code. Reports > Codes by segments.
With various selection options.
Export to Excel

[AlexandreGareau]

I do research in organizational psychology for the government. Treating each theme (code) as a column (variable) is a common practice for extra quantitative analyses with the goal of understanding who are those that spoke about each theme. The mixed-method can however be controversial for some qualitative method expert.

For using your added modification I am not sure which step to follow. For now I used the last release version 3.5. If I understand I need to install Python to load the most recent code. For now I would have to wait for my organization to allow this install on my computer. There is no work around for using source code, right?

[ccbogel]

You can use the source code, by following the install instructions. Or installing on another non-work machine. Potentially an early exe could be prepared.