Hi All
could someone please assist on below issue?
Input:
Product | Count | Batch | Rating | Value | Val | rating -1 | Age | Aval | rating -2 |
Samsung | 331 | 3 | L3 | [Null] | [Null] | [Null] | [Null] | [Null] | [Null] |
Samsung | [Null] | [Null] | [Null] | -148480035.2 | 5 | L5 | [Null] | [Null] | [Null] |
Samsung | [Null] | [Null] | [Null] | [Null] | [Null] | [Null] | 100 | 1 | L2 |
required output:
Product | Count | Batch | Rating | Value | Val | rating -1 | Age | Aval | rating -2 |
Samsung | 331 | 3 | L3 | -148480035.2 | 5 | L5 | 100 | 1 | L2 |
Solved! Go to Solution.
@Anjankumar2021 Add a summarise tool and select all field for the Max value
thank you so much:)