topic tReplaceList queries in Talend Studio

tReplaceList queries

noobTalendDev — Fri, 15 Nov 2024 23:29:01 GMT

I am taking in an 'xls' file and there is one column on which i want to change the data so it will be easier to use.

input -> expected output

24 hours -> 1

5 days -> 5

1 month -> 30

1 year -> 365

so I am given the string and want to change it to the numerical interger.

I was thinking of using tReplaceList,

but wanted to see what other options were out there to handle this.

Full workflow:

Taking in an xls file and reading the values and adding up all of these integers based on the user to give you the full picture. So after this change i will be transforming the data still.

Re: tReplaceList queries

Anonymous — Thu, 25 Nov 2021 04:12:32 GMT

I think tReplaceList is the best component to replace the values , another way is to use tJavaRow to replace the values with Java code after reading the data from xls file.

Regards

Shong

Re: tReplaceList queries

noobTalendDev — Tue, 30 Nov 2021 17:30:17 GMT

for some reason tReplaceList doesn't do anything to my output, I used tJavaRow instead. Am I using tReplaceList wrong?

Re: tReplaceList queries

Anonymous — Wed, 01 Dec 2021 02:49:24 GMT

Would you like to share some screenshots to what you are doing with tReplacdList, we can check it.

Regards

Shong