topic Re: Can't change focus to Current Data Table in Discussions

Can't change focus to Current Data Table

twaintwist — Tue, 18 Oct 2016 20:00:51 GMT

I've created a summary table and now I'd like to manipulate the Summary Table and create a graph from it.....

But I can't seem to get the 'Current Data Table' command to work..... (see screenshot above)....

Re: Can't change focus to Current Data Table

wiebepo — Fri, 07 Sep 2012 01:03:36 GMT

consider using the following syntax to give a handle to your summary table:

summary_table_name=dt<<Summary(Group(:SORTonTHIS));

dt<<Sort(By(:N Row), Order(Descending));

summary_table_name<<Graph Builder(...);

Re: Can't change focus to Current Data Table

twaintwist — Tue, 18 Oct 2016 20:01:01 GMT

wiebepo --- thanks ----

It still is not switching to the Summary Table ---- it remains with the original datatable (which is called 'Script_temp') ---- you can see from the debug screen that 'dt' is still showing the original table and not the summary table after executing:

summary_table_name=dt<<Summary(Group(:SORTonTHIS));

Re: Can't change focus to Current Data Table

ms — Fri, 07 Sep 2012 12:31:15 GMT

dt is not supposed to change here. The table variable dt still linked to the original table because you have not reassigned it.

In the code you assign the summary table to the table variable summary_table_name (you can use almost any name). To sort that table use

summary_table_name<< sort(...);

If you want to make jmp to forget dt and reuse that name for the summary table, try:

dt = dt << summary(...) ;

But that's not wise if you'll need to address the original table later in the script. Look

Re: Can't change focus to Current Data Table

twaintwist — Fri, 07 Sep 2012 13:24:28 GMT

Thanks ---- Obviously I was confused --- thanks for clearing that up for me

Re: Can't change focus to Current Data Table

twaintwist — Tue, 18 Oct 2016 20:01:11 GMT

I'm still having problems understanding what I can and can't do with a separate dataTable....

For the Summary table I've successfully created two new columns, populated another with data and now I'm trying to concatenate two columns on the Summary table called 'ParetoTable'...

ParetoTable << For each Row(:ProductProblemCategory_=:Order || :ProductProblemCategory);

Nothing happens --- see log screenshot ------ but occasionally I get an error in the log saying that 'ProductProblemCategory_' is not an L-value...etc..

Re: Can't change focus to Current Data Table

ms — Mon, 10 Sep 2012 08:59:33 GMT

I don't think For Each Row() can be used as a message in the JSL syntax. Think of it as a function that applies to the current data table.

Try either to first make sure that PeretoTable is the current data table and then the row-wise concat:

ParetoTable=current data table();

for each row(ProblemProductCategory_ = :Order||:ProblemProductCategory);

Or use the dt:col syntax to explicitly address the columns:

for each row(ParetoTable:ProblemProductCategory_ = ParetoTable:Order||ParetoTable:ProblemProductCategory);

Re: Can't change focus to Current Data Table

twaintwist — Mon, 10 Sep 2012 15:08:05 GMT

MS --- thanks ---- they both worked....