nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

how do you export the results table

frazman

Hi.
First of all, thanks for all the members here for getting me started.
I am able to make the start now and have started delving into actual ML stuff.
So, I am trying to build a simple k-NN classifier and I have been able to succesfully test it in unlabelled data.
I have a very basic question.
In the results section, the tables we get..
how do we export those tables in excel sheet
The table in --> Example set--> Data view.
How do i export the tables which can be read in excel format.
Thanks.

Find more posts tagged with

AI Studio

Accepted answers

colo

Hi frazman,

since you can see the results in the results view, you have probably connected the data flow from the last operator to the results port of the process. If you just append the "Write Excel" operator to the end of the process, you can easily export the table (the things you see in the data view) into an excel file.

Regards
Matthias

All comments

colo

frazman

oh great! thanks a lot..

patku

colo wrote:

since you can see the results in the results view, you have probably connected the data flow from the last operator to the results port of the process. If you just append the "Write Excel" operator to the end of the process, you can easily export the table (the things you see in the data view) into an excel file.

What if we have the results of a long-running process and we don't want to run it all over again? Do you have to save the results in a repository and create a new process to retrieve those results and write to file, or is there a more straightforward approach? (EDIT: I found that selecting all cells and copying, then pasting into Excel is probably the easiest, although the headers aren't included that way.)

EDIT: Apparently only enterprisers get this nice feature:

Sebastian Land wrote:

this functionality is part of the enterprise version only. There you can export every table format into an excel sheet...

In my case, neither seems to work because I have association rules and the "Write to xxx" operators all want an example set. Although there is a conversion operator that goes from frequent item sets to data, there doesn't seem to be one for association rules. Any ideas about that?

MarkusW

I wish I knew that, before I started training a machine

MarkusW

Okay, @colo which exit(s) from the Crossvalidation do I have to put into "Write Excel" and where does the file end up? If left it running and all I got was the Description "Memory Buffered File"

MartinLiebig

@MarkusW ,

this is a very old thread. But what you want to do is not connect the purple fil port of Write Excel, but only the blue exa port.

Cheers,

Martin

MarkusW

Thanks, I just didn't want to open a new one, when in essence the problem was already solved.

So Crossvalidations Exa goes into Write excels inp, put Write Excels outputs go unused (This last part, was what I did wrong, when I tried it, I connected the output to res, because I thought that was required to view the results).

Where does the file than go/where can I find it, so I can open it?

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events