Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

CDC

Highlighted
Seven Stars

CDC

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
Highlighted
Thirteen Stars

Re: CDC

your question is not clear can you explaine?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Highlighted
Seven Stars

Re: CDC

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
Highlighted
Nine Stars

Re: CDC

Can you clearly describe the result in My output?

Highlighted
Seven Stars

Re: CDC

@manishchokkaram
What do you mean by my output?

Thanks,
Lmit
Highlighted
Seven Stars

Re: CDC

Hi all,

Any suggestions or help would appreciate

Thanks
Lmit

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog