Error message "Output column has 1 rows while the table has 3 rows" in TERR

[Rui Li]

Hello everyone,

I got the following TERR error message with my R script. I am trying to have the output as a vector, however, TERR takes it as a row. I cannot figure out how to map the output correctly into spotfire datasheet.

hank you very much!

Rui

 

Here is error message:

Adapting output columns to result table row count.

All columns in an add columns operation need to have the same row count as the data table. Output column has 1 rows while the table TEST (2) has 3 rows.

---

Here is my R script (the code is redundant, as it is a part of a long script. The statement in for loop is just an example to show the problem)

raw_pars

[Gaia Paolini]

Hi

this is a very long script and you give no sample data and no details of where exactly the error occurs.

A useful way of debugging such situations is:

1. place a statement like this:

save.image('C:/Debug/myscript.RData')

as a first statement of your TERR script, where C:/Debug is just an example of afolder. As long as it exists, any name is fine, same for the file.

2. run your script within Spotfire to generate the image file, does not matter if it gives the usual error

3. copy and paste your script into an editor e.g. RStudio pointing at TERR

4. replace the save.image with load

5. run the script line by line

In order to open RStudio on TERR, you can go, from within Spotfire, to Tools>TERR Tools> Launch RStudio IDE. It will open RStudio pointing to the TERR version you are currently running within Spotfire. You can verify it by running the 'version' statement.

Gaia

[Rui Li]

Hi Gaia,

 

Thank you very much! I kind of figured out where the problem was: I did not specify the output correctly. However, I still cannot figure out what to do. 

 

I take data from columns of Data Table as inputs, and I am trying to add a new column as the output. But with a for loop, Spotfire or TERR is confused with my output dimension. Could you tell me what I should do

 

I have simplified the script to a few lines, and uploaded the data file.

 

Rui

[Gaia Paolini]

Hi

 

can you please upload the dxp The key is probably in how you define inputs and outputs.

 

Gaia

[Rui Li]

Hi Gaia,

 

Thank you for your recommendation! While I was preparing dxp file, I found that it was a problem of how I defined the output. It worked after I deleted the old settings, and redefined all the inputs and output. 

 

Rui

[Rui Li]

I will delete this question later, as it does not seem to be useful to others. 

[Gaia Paolini]

Hi

This is now a different question to the one I answered.

It seems rather confusing. It is no longer a very long script and the error is different.

Tips about debugging a TERR script are useful to the community, but it is better to ask a new question in this case, rather than changing the original question.

Gaia