topic Re: Trans-code a sequence of number from CSV into text values in Data Quality

Trans-code a sequence of number from CSV into text values

Anonymous — Sat, 16 Nov 2024 07:28:31 GMT

Hi everyone,

My need is to convert a sequence of numbers from a CSV into text values (new columns). For example: 121914 has to be splitted in 3 couple of numbers and map with 3 text values such as: 12 -> 'A', 19 -> 'B', 14 -> 'C'.

Is it possible with Data Quality tool or Data Preparation (Data Integration)?

Thanks a lot,

Skender

Re: Trans-code a sequence of number from CSV into text values

Anonymous — Mon, 29 Oct 2018 08:41:56 GMT

Hello,

@skollcaku wrote:

Hi everyone,

My need is to convert a sequence of numbers from a CSV into text values (new columns). For example: 121914 has to be splitted in 3 couple of numbers and map with 3 text values such as: 12 -> 'A', 19 -> 'B', 14 -> 'C'.

Is it possible with Data Quality tool or Data Preparation (Data Integration)?

Thanks a lot,

Skender

What's the logic for Trans-code? Trisection?

Best regards

Sabrina

Re: Trans-code a sequence of number from CSV into text values

Anonymous — Tue, 30 Oct 2018 09:31:27 GMT

Dear Sabrina,

thanks for reaching out!

What I meant by transcoding is a mapping table in order to assign the corresponding values based on that table (a kind of lookup).

At the end, we used Talend Integration Cloud and tMap and for some examples we used the custom routines (Java expressions) to process the data. So, the problem has been resolved by now.

But, thank you a lot for your interest!

Br,

Skender