topic Re: Update column value from another table using wildcard in Discussions

Update column value from another table using wildcard

UserID16644 — Tue, 10 Oct 2023 04:08:32 GMT

Hi all, is it possible to update a column from values coming from another table using wildcard as key? I have this example table but doesn't know how to use wildcards properly in updating tables. Also, I am still using JMP 15 version

Table A

Id_A	Model	Status	Start Date	End Date
23-ABC-AA	A	Done	2023-10-01	2023-10-05
23-ABD-BB	B	Done	2023-10-02	2023-10-07
23-ACD-BB	C	Ongoing	2023-10-03	2023-10-09

Table B (file to be updated, start/end date initially has no values, but when their IDs match using wildcard, it will then be updated)

Id_B	Model	Status	Start Date	End Date
23-ABC	A	Done	2023-10-01	2023-10-05
23-ABD	B	Ongoing	2023-10-02	2023-10-07
24-AAA	C	Done

Re: Update column value from another table using wildcard

txnelson — Tue, 10 Oct 2023 04:24:10 GMT

Given the example case you displayed, I do not believe there is a "Wildcard" capability in JMP. However, you can easily create a new column in table A that has as its value, the first 6 characters of column ID_A. Then that column can be used to match with the ID_B column in table B.

Re: Update column value from another table using wildcard

jthi — Tue, 10 Oct 2023 04:40:11 GMT

Depends a bit on what type of wildcard you need what would be easiest. In your example, I would create Id_B column to Table A by dropping the last part of Id_A.