Hi Knime Expert just need your help to solve problem of duplication.
Excel Reader 1 No of lines: 855
Excel Reader 2 No of lines: 157969
Excel Reader 3 No of lines: 79468
Excel Reader 4 No of lines: 932
As per Blueprint of Script I need to join file 1 & 2 using inner joint , and I am getting Output of no of lines = 62393 viz. is equal to output file requirement by client.
My problem starts when I am joining File 3 & 4 with output of joint of File 1 & 2 , where there is duplication. I have tried duplication filter to resolve the problem, I have tried Left Joiner , etc… but i am not getting expected result of 62393 lines.
Please provide your expert opinion of different permutation & combination I shall apply to get desire result .