Forum Discussion

FAMH's avatar
FAMH
Frequent Visitor
3 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.