nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't change focus to Current Data Table

twaintwist

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)....

Accepted answers

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

All comments

wiebepo

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(...);

twaintwist

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));

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

twaintwist

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

twaintwist

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..