Crosstable in Script editor

[danaleota1]

Hello,

I used the following Crosstable function in script editor :

Crosstable(Question, Scores, 14)

It worked fine, however the very last column- I want to have as qualifying column.  How do I keep this column as is ,even though it comes after the qualifying columns?  I know the third argument has preceding qualifying columns but is there a fourth argument for when to resume qualifying columns?  Thanks hope that made sense.  

[martinpohl]

no, there is no fourth argument.

If there is a column in your data that is a regular column, you have to use the column in the script above and set the third argument +1.

Regards

[Vegar · Accepted solution]

If you  have a fixed number of columns with fixed column names then you can just reorder the field in the load statement used with your crosstable prefix

Crosstable(Question, Score, 15)
LOAD 
  Field1,
  Field2,
  ...
  Field14 
  Field20, //The last field in your source
  Field15,
  Field16,
      ...
  Field19 //The second to last column in your source
FROM Source;

[danaleota1]

D'oh.  Thank you that was easy!