loess function for multiple columns

[Olga Vadzyuk]

Dear all,

I have a data table "mytable3" with a few columns and Ineed to smooth all columns with one script and have them all in one table. I have script, that works only for one column in time:

sp

[Fabian Duerr]

Please help us to help you and upload a simplified dxp file. A data table with 3-4columns and a few rows would be sufficient. Your file contains many tables and a lot of data functions. Also, the data is not embedded but linked to some local csv files. 

 

A few more comments on how you handle the data (input, output: Columns or tables) would be good as well. 

[Olga Vadzyuk]

Thank you for your kindhelp!I have modified file as you recommended: embedded data and deleted some columns and rows.

I have three inputs:

x column - type "Column" (in my data, x - is a "Temperature" column)

y column - type "Column"

Span - type value

and one output:

loess - type table.

It is clear for me why this script process only one column - when I change data type from "column" to "table" - it fails. But how to modify it in a way that it can process all columns at once - its a problem for me now.

Sorry my inexperience, I am new to TIBCO and scripting

Olya

[Fabian Duerr]

Please use the following script for your data function. The input (input.table) should be a table where you select your x-axis (Temperature) and all y-columns that you want to fit/smooth. If you want to modify the span, you need to create the a document property and add it as input. (This property was not availabe in your file. So, I set it to 0.5)

#get all columns from input table

cols

[Olga Vadzyuk]

Thank you so much!!!