Update column value from another table using wildcardHi 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 | | |
Automation and ScriptingRe: Update column value from another table using wildcardGiven 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 wildcardDepends 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.
