Changing Keyword based on business rules

Four Stars

Changing Keyword based on business rules

Hi

 

I am new to Talend Studio and I'm trying to figure out if Talend Open Studio DQ  can do this or if I need something else. Assuming I have a column of data for database type, and I have entries such as MS SQL 2012, Microsoft SQL 2012. Microsoft 2012 SQL, etc Can I a. Change MS for Microsoft as part of the validation? Can I create a look up where all as set of possible MS SQL 2012 gets updated t MS SQL 2012 Workgroup Ed (as example)?

 

Thanks in advance.


Accepted Solutions
Eight Stars

Re: Changing Keyword based on business rules

You should be able to do this using tMap: you would use the Find/Replace expression to replace "MS" with "Microsoft" in the output element. Your input to tMap would be something like tFileInputDelimited, tFileInputExcel, etc., and your output would be whatever format you want to save the file in.

 

Good luck!

 

David


All Replies
Eight Stars

Re: Changing Keyword based on business rules

You should be able to do this using tMap: you would use the Find/Replace expression to replace "MS" with "Microsoft" in the output element. Your input to tMap would be something like tFileInputDelimited, tFileInputExcel, etc., and your output would be whatever format you want to save the file in.

 

Good luck!

 

David

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read