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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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