how should I export my result of Documents' Cluster Analysis to Excel file

[ingridfar]

hello,how should I export my result of Documents' Cluster Analysis to Excel file?
I want the "id" information and word list of the result

[ko-ichi-h]

What do you mean by "word list"? The cluster analysis of documents returns only cluster numbers each document belongs to.

Anyway, you can export the cluster numbers and id in this way:

Basically,

1. Save the result of cluster analysis as a variable
2. Export the variable as *.csv file
3. Open the *.csv file with Excel

"No." is identical with the "id".

[ko-ichi-h]

"No." is identical with the "id".

Oh, the "id" is a variable (column) in your input data file, right?

In that case, "No." is not identical with the "id". Sorry.

And in that case, you have to choose both "id" and "cluster" in the list of variables then click "Export". To choose multiple variables in "List of Variables & Heading" window, hold down "Ctrl" key and click variables.

[ingridfar]

Thank you for your prompt response.

And yes, there are two columns called "id" and "host_about" in my input data file. I use the "host_about" column as my Target Column.

The problem is after I finishing exporting the result as *.csv file, I can not find the "id" in the list of variables. what should i do...

[ingridfar]

and this is the result of export

[ko-ichi-h]

Did you see "id" in "List of Variables & Headings" window before? If yes, it seems that you accidentally deleted "id" variable. I think you accidentally clicked "Delete" button.

To get "id" variable in the KH Coder project again, you can create a *.csv file that only contains "id" column and import it from "List of Variables & Headings" window. Alternatively, you can just delete the current project and create a new project from the input file again.

[ingridfar]

thank you !!!
I made it! :)