I am working on a text mining project including both clustering and classification of free-text data.
After the clustering and classification is completed I would like to insert the results into my original excel file so that it can be used for other purposes. However, in the output it seems like the order of the data doesn’t match the Excel file.
Does anyone know of a convenient/any solution to this challenge?
Maybe you can use following approach. Add identifier to original data which you’ll keep along your workflow so you can join results back once clustering and classification is done
For identifier column you can use Counter Generation node or simply ROWINDEX function from Math Formula node. Hope this helps!
I have a component that creates an auto increment column. It wraps around the Counter Generation and allows you to specify the column name for the auto increment column. It handles column name collision: