1

In using the dataset SP500W90 for Artificial Neural Network in SPSS Modeler, I have a simple stream below.

It generate a result of accuracy 90.9%.

enter image description here

I want to output the predicted values side by side with the existing “closing”, however it doesn’t create an Excel file.

Here’s the setting in the Excel node.

enter image description here

How can I output the prediction in Excel file (side by side with the original “closing”)? Thank you.

eli-k
  • 10,898
  • 11
  • 40
  • 44
Mark K
  • 8,767
  • 14
  • 58
  • 118

2 Answers2

1

The images are not being shown for me. But, in order to export to Excel, you have to use a Type node in front of the Export Excel node. You have to set all type of variables inside the Type Node and then export. And if you want to choose the order of appearence of the variables in the Excel file, use the Field Reorder node before the Export Node.

Check the references from IBM for more details:

Ref 1 - Field Reorder Node

Ref 2 - Type Node

Hope to have been helpful!

Érica Wong
  • 119
  • 6
1
  1. I would swap the Partition and Type node places. Partition field needs to be instantiated.
  2. Your diamond node (the algorithm) has to be connected to the data flow, that is the Partition node in your case.
  3. Put a Type node before extracting to Excel. You may need to rename the field starting with $ through a Filter node.
  4. You could also do much painless job extracting to csv / flat file. :)
Julian
  • 154
  • 1
  • 11