Search code examples
neural-networkspss-modeler

Excel output of SPSS Modeler

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.

Solution

  • 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!