Hi, I want to aggregate the quantity from table left based on the picking time, then copy the aggregate quantity into table right. For instance, it should be quantity = 8 for time = 20 and put it on corresponding row on table right (table attached)
I used this code on reset trigger, but it doesn't works. It said that there is an invalid condition type on my IF CONDITION. Somebody help me please. Thanks
/**Custom Code*/ Table current = param(1); //Table node Array Quantity = Array(44); int k = 0; for (int i = -15; i <= 28; i++) { k += 1; Quantity[k] = 0; for (int j = 1; j <= Table("ScheduledPicking_CO").numRows; j++) { if (Table("ScheduledPicking_CO")[j][1] = i) { Quantity[k] += Table("ScheduledPicking_CO")[j]["Quantity"]; } } } for (int l = 1; l <= Table("PickingReady_CO").numRows; l++) { settablenum("PickingReady_CO",l,2,Quantity[l]); }