Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 files (one is history file and the other is current file)
the history file has a column called Commidty_Code and data in this is like "1|2|3"
the current file also has the same data in commidty_code but the current file can have new values add or removed like "1|2|3|4" or "2|3|4"
so I have to compare these 2 columns(commidty_Code) and output should be
if a new value is added in new file and one value got removed from old file then output in that column should be "2|3|4" 1.e.,
historyfile:
id;commidty_code
1;1|2|3
CurrentFile:
id;commidty_code
1;2|3|4
outputfile:
id,commidty_code
1;1
1;2|3|4
SO should i first normalize the data in the commidty_code and then compare data ?
Suggest any good logic or help me get the output to achive my requirement
Thanks in Advance
Lmit