Forum Discussion
Data Extraction from a column based on a value from another table
Hello Community ,
I have Two Table
Table 1 : with a column where there a colum Description :
| Row | Description |
| 1 | D100001andD203456 |
| 2 | D100001-Action done |
| 3 | VendorID254678 |
and getting a new table :
| Row | Description |
| 1 | D100001 |
| 1 | D203456 |
| 2 | D100001 |
| 3 | D254678 |
Table 2 :
| ID |
| D100001 |
| D203456 |
| D254678 |
Is it possible to Extract all the ID from Description in table 1 and Link them to table 2
Does any one have a idea or a suggestion ?
Best Regards
Thank you for your help
Hi FAMH ,
You can split the Description column with "D" to rows and then extract numbers.
Splitting
Extracting
After removing and renaming the columns, you get the new Description column.
And you can create the relationship between two tables.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi FAMH ,
You can split the Description column with "D" to rows and then extract numbers.
Splitting
Extracting
After removing and renaming the columns, you get the new Description column.
And you can create the relationship between two tables.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.