Alteryx to Knime - Tile Function
We have a portion of a predictive model (to estimate close rates of open opportunities) that uses the Tile and Running Total functions in Alteryx to calculate win rates based on a number of factors (product, source of opp, etc.). Essentially all won proposals are assigned a value of 1, and all lost proposals are assigned a 0. Proposals are ordered according to date created, and assigned a TileNum (which is based on the product type - i.e. all proposals for product A are assigned a “1”, all proposals for product B are assigned a “2”, etc.) and a TileSequenceNum (which is numeric based on the placement of the record within the “Tile”). The running total of “won” proposals is then compared to the tile sequence number of the product to produce a current win rate.
Is there an effective way to replicate this in Knime? See example below:
| createdon | Win_Status_Numeric | Product | Tile_Num | Tile_SequenceNum | RunTot_Status_Numeric | Win% |
| 10/2/2020 16:36 | 0 | A | 1 | 1 | 0 | 0 |
| 10/8/2020 16:28 | 0 | A | 1 | 2 | 0 | 0 |
| 10/15/2020 15:52 | 0 | A | 1 | 3 | 0 | 0 |
| 10/21/2020 18:22 | 0 | A | 1 | 4 | 0 | 0 |
| 10/22/2020 16:54 | 0 | A | 1 | 5 | 0 | 0 |
| 10/26/2020 17:17 | 0 | A | 1 | 6 | 0 | 0 |
| 10/26/2020 18:45 | 0 | A | 1 | 7 | 0 | 0 |
| 11/2/2020 21:55 | 0 | A | 1 | 8 | 0 | 0 |
| 11/3/2020 20:09 | 0 | A | 1 | 9 | 0 | 0 |
| 11/4/2020 17:19 | 1 | A | 1 | 10 | 1 | 0.1 |
| 11/4/2020 19:00 | 0 | A | 1 | 11 | 1 | 9.09E-02 |
| 11/4/2020 21:45 | 0 | A | 1 | 12 | 1 | 8.33E-02 |
| 11/4/2020 22:58 | 0 | A | 1 | 13 | 1 | 7.69E-02 |
| 11/5/2020 17:26 | 0 | A | 1 | 14 | 1 | 7.14E-02 |
| 11/5/2020 20:30 | 0 | A | 1 | 15 | 1 | 6.67E-02 |
| 11/9/2020 14:35 | 0 | A | 1 | 16 | 1 | 0.0625 |
| 11/9/2020 14:36 | 0 | A | 1 | 17 | 1 | 5.88E-02 |
| 11/9/2020 17:28 | 1 | A | 1 | 18 | 2 | 0.111111111 |
| 11/9/2020 17:55 | 0 | A | 1 | 19 | 2 | 0.105263158 |
| 11/10/2020 17:07 | 0 | A | 1 | 20 | 2 | 0.1 |