Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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
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;
D'oh. Thank you that was easy!