topic Re: CDC in Talend Studio

CDC

lmit — Fri, 08 Mar 2019 10:38:33 GMT

Hi all,
I have 2 input files as below
1st file:
S.no~community_code~amount
1~12~45.0
1~13~45.0
1~14~45.0
Second file
S.no~community _code~amount
1~13~45.0
1~14~45.0
1~15~45.0

My output should be
S.no~community_code~amount
1~12|13|14~45.0
1~12~-45.0
1~13|14|15~45.0

My second file is previous month file and I need to compare it with current file to check whether the community code have any changes
In both the files the commodity _code column will have data with | separator like how I shown in my output

Please suggest any good logic to implement it, because before comparing I have to normalise and again after comparing and getting values I have to denormalise

Thanks in advance,
Lmit

Re: CDC

fdenis — Fri, 08 Mar 2019 11:26:13 GMT

your question is not clear can you explaine?

Re: CDC

lmit — Fri, 08 Mar 2019 12:28:35 GMT

Hi fdenis,

Thanks for your reply

No I have showed only the matching records. Ids will be different but amount can be same or may not be

Thanks,
Lmit

Re: CDC

Anonymous — Fri, 08 Mar 2019 15:22:08 GMT

Can you clearly describe the result in My output?

Re: CDC

lmit — Fri, 08 Mar 2019 15:38:06 GMT

@ksingh
What do you mean by my output?

Thanks,
Lmit

Re: CDC

lmit — Mon, 11 Mar 2019 05:25:16 GMT

Hi all,

Any suggestions or help would appreciate

Thanks
Lmit