Column Expression

Dear Knime experts and enthusiasts! Need some help.

Input is like

Document Number Reference no. Claim (unique concatenate) Reference document (unique concatenate) SUBMITTED AMT CREDITED AMT TOTAL AMT SUB AMT - CRD AMT Total amt - Credited amt
112018984 0331GSUAL 10025510, 100258783 , 10025510 20912.08 20904.91 20903.64 7.17 -1.27
112019935 0331GSUAL 10025510, 100258783 , 10025510 20912.08 20904.91 1.27 7.17 -20903.64

and I want Output as

Reference no. Claim (unique concatenate) Reference document (unique concatenate) SUBMITTED AMT CREDITED AMT TOTAL AMT SUB AMT - CRD AMT Total amt - Credited amt
0331GSUAL 10025510, 100258783 , 10025510 20912.08 20904.91 20903.64 7.17 0
0331GSUAL 10025510, 100258783 , 10025510 1.27 7.17
20904.91

Hi @ravi13

The only difference I can see between your input and output is that the output doesn’t have a Document Number column. Can you either reformat your examples or actually upload the example data files?

It would also be helpful if you provided a more thorough explanation of what you’re tying to accomplish.

3 Likes

Hi @ravi13,

agree with @elsamuel. Also try giving better topic name as question is not related to Column Expressions node. I guess you maybe tried solving your problem with it but still…

Br,
Ivan

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.