Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression mapping and filtering

Hello,

 

I'm wondering if it is possible to do this. I have a file that I will going to load to the table. So from file, I have a data for column CatDog_Count on the destination table I have a column Dog Count.

 

On CatandDogcount Column there is a value like this:

The count of a dog is 45623

 

I only want the numbers to be inserted on the destination table or on Dog Count column, so that I can remove those "The count of a dog/cat is". What should be the right syntax/command for that? Thanks for any help!

Labels (2)
2 Replies
Anonymous
Not applicable
Author

UP

Anonymous
Not applicable
Author

Hi,

 

    I believe this is a more generic version of your problem depicted in your another post (link below)

 

https://community.talend.com/t5/Design-and-Development/how-to-load-only-the-values-needed-using-tMap...

 

    Since I have given the answer for your other post, could you please mark this post also as resolved? 

 

Warm Regards,

 

Nikhil Thampi