Plotting a graph from csv containing multiple paths.

[Don Yusof]

I have a csv file as shown below. I assigned the columns "Category", "ModelNumber", "SerialNumber" and "Test" as filters. I would like Spotfire to plot a line graph based on the selected filters.

For example: I choose ModelNumber:A2300-2222 and SerialNumber:234567890, it would plot the graph from the path C:/Users/524712552.txt.

How can I do this

 

 

 

Category

ModelNumber

SerialNumber

Test

Path

 

 

 

 

Adjustment

A1200-1111

123456789

Image

C:/Users/123456789.txt

 

 

Adjustment

A2300-2222

234567890

Image

C:/Users/524712552.txt

 

 

Adjustment

A2445-12667

3456721192

Image

C:/Image/62516662.txt

[Fabian Duerr]

You could create a data functions that takes your filtered table as input. This data function then loads the txt file (=path) into a table. This table is the output of your data function. The data can be displayed in a visualizations.

You may want to ensure that your input table is filtered to a single line. (Of course, you can write a function that loads data from multiple files as well). You can also work with MARKING instead of filtering. Also, ensure that the structure of your txt file is consistent. This will make it easier to load the data. If you use a R data function then read.table() or read.csv() should do the job.