cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
Choose Language Hide Translation Bar
NewToThis
Level I

Mapping Columns in two different Tables by manual Selection using JSL

I have two tables, let call them dt1 and dt2

Each table has one column each Column1 in dt1 and column2 in dt2.

I need to (either update or create a new table ) that has contents of Column1 mapped to to contents of Column2 by manual selection. Since the column entities are so different a join or update feature cannot be used. 

My aim is to create a user interface that allows the user to select row by row matching of content in the two columns. 

NewToThis_0-1749143273299.png

 

11 REPLIES 11
jthi
Super User

Re: Mapping Columns in two different Tables by manual Selection using JSL

I assume it would just be single column from both tables? I should have time today to add needed updates to the script.

-Jarmo
jthi
Super User

Re: Mapping Columns in two different Tables by manual Selection using JSL

Creating this will take longer than I expected as user has to be also able to pick the second table which makes it very messy due to how all "nice" display boxes behave when tables change (looking at filter col selector and col list box...). And I have less time in the evening than I hoped I would have.

 

I also started creating more complicated UI but I realized that there really isn't a point as JMP's Recode platform should do all this. I suggest you create a wish list item about this (I can also create one, I do have few extra suggestions also)

 

View more...
jthi_0-1749738216836.png

 

-Jarmo

Recommended Articles