When Sum is greater than 4 move the remaining data to new file

[sbxr]

Hi,

I have a excel file which I need to take using tfilelist, in that file I have data as below

FILE-1

Equip | Qty

PH,     1

PH,     2

PH,     1

AQ,     2

AQ,     1

Now what I need to do is groupby Equip and Sum the value of Qty like below:

Equip | Qty

PH,     4

AQ,     3

and after this we need to check if the PH sum is greater than 4 move the reaming Data to new file?

How to perform this Job please help me with this.

[TRF · Accepted solution]

tAggregate to sum values by Equip then tFilterRow to decide if PH row must go to output file 1 or 2.

Is that what you expect?

[Anonymous]

I would suggest adding  a tfilterRow component where you can put the required condition.

Now you'll get two outputs. One meeting the condition and the one not meeting it.

For the 2 outputs configure two different files.

Hope it should help.