topic Comparing the first 2 digits of postal code to another colomn in Talend Studio

Comparing the first 2 digits of postal code to another colomn

Anonymous — Mon, 04 Mar 2019 10:14:55 GMT

Hello everyone,

I'm a beginner on talend and I will apprecitate if someone can help me with this...

How to match the first 2 digits of a postal code ex: 69000 to another column containing the value 69. Then only show row where these values match. (Excel file with the full data attached)

Example of the data below:

5	TELMAT INFORMATIQUE	69000	LYON	66	pyrenees-orientales
5	TELMAT INFORMATIQUE	69000	LYON	67	bas-rhin
5	TELMAT INFORMATIQUE	69000	LYON	68	haut-rhin
5	TELMAT INFORMATIQUE	69000	LYON	69	rhone
5	TELMAT INFORMATIQUE	69000	LYON	70	haute-saone
5	TELMAT INFORMATIQUE	69000	LYON	71	saone-et-loire
5	TELMAT INFORMATIQUE	69000	LYON	72	sarthe
5	TELMAT INFORMATIQUE	69000	LYON	73	savoie

Thanks in advance

Re: Comparing the first 2 digits of postal code to another colomn

TRF — Mon, 04 Mar 2019 10:26:55 GMT

If postalCode is defined as an integer, use a tFilterRow to get rows where the values is between 69000 and 69999.
If string, extract first 2 digits first then tFilterRow to get expected result.

Re: Comparing the first 2 digits of postal code to another colomn

Anonymous — Mon, 04 Mar 2019 12:43:51 GMT

Thank you for your response,

I don't think you got my question right, please take a look on the attacked excel file file.

The 69000 was just an example, so actually there are several postal codes and several departementIDs that starts with varoius ranges of numbers and characters which needs to be matched, am not sure if tFilterRow can be usful in this case.

Re: Comparing the first 2 digits of postal code to another colomn

akumar2301 — Mon, 04 Mar 2019 13:40:21 GMT

But Why your input is cross joined with Region Code ?

Anyways , Try tFilterrow (Use advance Option) with expression ( to check if col3 starts with Col5 )

StringHandling.INDEX(input_row.col3 + "",input_row.col5 + "") == 0

You could use regex expression also.

Re: Comparing the first 2 digits of postal code to another colomn

Anonymous — Mon, 04 Mar 2019 14:39:29 GMT

Many thanks Abhishek it works just fine