topic Re: Flag changing in tmap in Talend Studio

Flag changing in tmap

lmit — Sun, 04 Mar 2018 19:16:32 GMT

Hi All,

I have a requirement where I need to change flag from y to n based on a condition.my data looks like below
Id;flag
1;y
2;y
1;
My output should be
Id;flag
1;n
2;y
1;y
If ids are same and have a flag value as y then it has to change to n and if the flag is null it has to change to y

Can anyone Suggest a solution, if so would be a great help.

Thanks in advance,
Lmit

Re: Flag changing in tmap

Anonymous — Mon, 05 Mar 2018 03:18:56 GMT

Hello,

You can use ternary operator for if-else scenario in tMap or join your two tables.

Condition?value if true:value if false

Best regards

Sabrina

Re: Flag changing in tmap

lmit — Mon, 05 Mar 2018 04:36:59 GMT

Hi Sabrina,,

Thanks for your reply . but can you be little bit clear about what you said??

Thanks in advance,

lmit

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 05:44:03 GMT

First sort the data based on Id and create create a Var for current Id and Previous Id and compare the Prevous Var with Current Var equls then y else n. use this way.

Re: Flag changing in tmap

lmit — Mon, 05 Mar 2018 06:05:01 GMT

Hi,

Thanks manohar for the reply.

the data in file can have n number of rows with same id and other ids which are not same like

id,flag

1,Y

2,Y

3,Y

1,Y

both the id's 1 with flag Y should be become N and with null should become N

but id's 2 with flag Y should be Y only

Thanks,

lmit

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 06:14:29 GMT

since you can sort the data based on Id Asc and Flag Asc order in tSortrow,you wil lget in required way and then you can compare in tmap and derive new flag.

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 06:48:58 GMT

If this help please give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 07:14:19 GMT

still you have issue?

Re: Flag changing in tmap

lmit — Mon, 05 Mar 2018 08:25:59 GMT

Yes Manohar,

Flag still not changing, after sorting and comparing also the flag is not changing.

for both values its changing, i mean for all values where Y is there is getting changed to N

Thanks,

Lmit

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 09:06:51 GMT

Can you show your job design?

Re: Flag changing in tmap

lmit — Mon, 05 Mar 2018 09:23:28 GMT

screenshot is not allowed to take,jib flow is as below

inputfile --> tuniqrow --> tmap --> outputfile

i appiled uniqrow on both columns id and flag

the output is :

1,N

1,Y

2,N

thanks,

lmit

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 09:32:57 GMT

why you used tuniqrow?i asked you to do sort using tSortrow

Re: Flag changing in tmap

lmit — Mon, 05 Mar 2018 10:59:17 GMT

sorry , my mistake i used tsortrow only

Re: Flag changing in tmap

Anonymous — Mon, 05 Mar 2018 11:04:28 GMT

row2.flag.equals("Y") ? "N": StringHandling.LEN(row2.flag)==0 ? "Y": row2.flag

use this expression

Capture.PNG

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 11:11:22 GMT

Could you please let me know the conditions and variable port in tMap

Re: Flag changing in tmap

Anonymous — Mon, 05 Mar 2018 11:14:51 GMT

hi pls find the attachment.

Thanks

Venkata Kiran

Capture2.PNG

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 11:32:25 GMT

Please find the attahced code.

Flag_changing.zip

Re: Flag changing in tmap

Anonymous — Mon, 05 Mar 2018 11:52:24 GMT

thats a good one bro

Re: Flag changing in tmap

manodwhb — Mon, 05 Mar 2018 11:58:58 GMT

If this help please give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Flag changing in tmap

manodwhb — Tue, 06 Mar 2018 04:24:01 GMT

@lmit still you have issue?