46432_en-US

liliconcom

Making changes across data tables

Hello!

  I have a large master data table which I have subsetted into at least ten other subsetted tables of that data for different analyses.  Occasionally I find mistakes in a data table and need to change a cell, column, etc.  Is there a way to have these changes carry across all the subsetted data tables without having to find the corresponding cell in each table and change it manually?

 

If so, does the effect only ripple in one direction? (This would affect which table I should make the change in.)

As I don't script in JSL, I am looking for an interactive solution

 

Thanks for your help!

Jennifer

Re: Making changes across data tables

You could open the source property of your non-linked table, insert "link to original data table(1)" and rerun the script, but any edits before the table was linked will not be updated in the original table.

 

Example:

<< Subset(
link to original data table(1), // insert this line to the source script and run
Selected Rows( 0 ),

 

Re: Making changes across data tablesBummer! Thanks for your help, though!Re: Making changes across data tables

I am not aware of any way to do such linking after a subset table has been created without the link.

Re: Making changes across data tables

Great!

  How do you link already subsetted tables?

Re: Making changes across data tables

Linking of tables allows you to make changes in any of the linked tables, and they will reflect the same changes in all of the linked tables.  An easy way to validate the linking is to select a row in the linked table, and it will select the row in the other tables that is linked to it.

 

 

Re: Making changes across data tables

Dear Jim,

  I thought I had done that, but it doesn't seem to let changes ripple across the subsetted data tables like I'd expect it to.  Is there any way to go back and check to see if it is done after the subsetting has occured?  Perhaps even (re)link the data table now?

Thank you for your help!

Jennifer

Re: Making changes across data tables

When you use

     Tables==>Subset

you can select the option to Link to Original data table