Select Pivot Table via Syntax

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Select Pivot Table via Syntax

Jignesh Sutar
Hello,


I would like to call up the following scrip via syntax (
http://www.spsstools.net/Scripts/PivotTables/ExchangeRowsAndColumnsOfPivotTable.txt
)

However, a pivot table must first be selected for the Scrip to run. How do I
go about doing this, (selecting a pivot table using syntax?)?

 Many thanks in advance
Jignesh

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: Select Pivot Table via Syntax

Sarraf, Shimon Aaron
You should also be able to find a script at the same location that selects on pivot tables. Once you locate the script file, integrate syntax similar to this into your syntax file:

script file ='c:\temp\SelectLastTableInCurrentOutput.sbs'.

Place this syntax before referencing the script you want to run.

If you can't find the script, let me know and I'll forward the file that I've been using.

Take care,

Shimon

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of J Sutar
Sent: Thursday, July 24, 2008 12:48 PM
To: [hidden email]
Subject: Select Pivot Table via Syntax

Hello,


I would like to call up the following scrip via syntax (
http://www.spsstools.net/Scripts/PivotTables/ExchangeRowsAndColumnsOfPivotTable.txt
)

However, a pivot table must first be selected for the Scrip to run. How do I
go about doing this, (selecting a pivot table using syntax?)?

 Many thanks in advance
Jignesh

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD