Hi Everyone,
So lets Say i have a Gl that has 100 Transactions and there are 10 Accounts Code each having 10 Transactions, so by using Alteryx I want to Separate the Transactions for each Account Code to become as a set of new Data where I can Apply Random % Samples and then I will Later on Join the Seperated Data into one GL.
| Transaction ID | Date | Description | Amount | Debit | Credit |
| 1001 | | 2/7/2024 | Utilities | 917.01 | 917.01 | 0 |
| 1001 | | 2/9/2024 | Raw Materials | 683.83 | 683.83 | 0 |
| 1001 | | 2/7/2024 | Supplier Payment | 269.31 | 0 | 269.31 |
| 1002 | | 2/8/2024 | Office Rent | 952.14 | 0 | 952.14 |
| 1002 | | 2/4/2024 | Raw Materials | 409.29 | 409.29 | 0 |
| 1002 | | 2/2/2024 | Sales Revenue | 884.35 | 0 | 884.35 |
| 1003 | | 2/1/2024 | Sales Revenue | 755.42 | 755.42 | 0 |
| 1003 | | 2/8/2024 | Raw Materials | 855.84 | 855.84 | 0 |
| 1003 | | 2/6/2024 | Utilities | 675.23 | 0 | 675.23 |
| 1004 | | 2/7/2024 | Raw Materials | 168.64 | 0 | 168.64 |
| 1004 | | 2/5/2024 | Raw Materials | 926.34 | 0 | 926.34 |
| 1004 | | 2/9/2024 | Office Rent | 873.54 | 0 | 873.54 |
| 1005 | | 2/8/2024 | Utilities | 519.52 | 0 | 519.52 |
| 1005 | | 2/2/2024 | Raw Materials | 190.25 | 190.25 | 0 |
| 1005 | | 2/1/2024 | Utilities | 113.08 | 0 | 113.08 |
