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
