Hi,
Good days!!!!
I would like to know if is it possible to transform below data (Source data) to a desire format (Result) by using Alteryx?
Cash = 111
Trade Receivables = 112
Other receivables = 113 +114 +115 +116
PPE = 121 +122
Payables = 131 + 132 +133 +134
Source Data
| | Description | A | B | Total |
| 111 | Cash | 543,543 | 234 | 543,777 |
| 112 | Receivables | 1,325 | | 1,325 |
| 113 | Prepayment | 345 | | 345 |
| 114 | Accrued | 53 | | 53 |
| 115 | Advance | 12 | 43 | 55 |
| 116 | Deposit | 3,453 | | 3,453 |
| 110 | Total asset | 548,731 | 277 | 549,008 |
| 121 | Motor | 12,315 | 345 | 12,660 |
| 122 | Depreciation | (21) | (46) | (67) |
| 120 | Total non-current | 12,294 | 299 | 12,593 |
| 131 | Payables | 435 | 53 | 488 |
| 132 | Loan | 123 | | 123 |
| 133 | Accrual | 3,425 | | 3,425 |
| 134 | Tax payables | 123 | | 123 |
| 130 | Total payables | 4,106 | 53 | 4,159 |
Result
| Description | | Total |
| Cash | | 543,777 |
| Trade receivables | | 1,325 |
| Other receivables | | 3,906 |
| | | 549,008 |
| | | |
| PPE | | 12,593 |
| | | 12,593 |
| | | |
| Payables | | 4,159 |
| | | 4,159 |
Thanks in advance
