Data Extraction from a column based on a value from another table

[FAMH]

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 

[Anonymous · Accepted solution]

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.