Hello,
I have a requirement of arranging data in multi horizontal table. Any advice on how to achieve this is greatly appreciated.
Below sample, i am trying to compare the client payment date and amount with my system details.
Input 1
| Pay Date | Client | Client | Client | Client | Client | ||||
| AAA | BBB | CCC | DDD | EEE | |||||
| 11/1/2024 | |||||||||
| 11/2/2024 | |||||||||
| 11/3/2024 | |||||||||
| 11/4/2024 | $600 | ||||||||
| 11/5/2024 | |||||||||
| 11/6/2024 | $700 | ||||||||
| 11/7/2024 | |||||||||
| 11/8/2024 | $900 | ||||||||
| 11/9/2024 | |||||||||
| 11/10/2024 | $550 | ||||||||
| 11/11/2024 | |||||||||
| 11/12/2024 | $250 | ||||||||
| 11/13/2024 | |||||||||
| 11/14/2024 | |||||||||
| 11/15/2024 |
Input 2
| Pay Date | My System | Payment |
| 11/4/2024 | AAA# | $600 |
| 11/6/2024 | BBB# | $700 |
| 11/9/2024 | CCC# | $900 |
| 11/10/2024 | DDD# | $550 |
| 11/13/2024 | EEE# | $250 |
Output:
| Pay Date | Client | My System | Client | My System | Client | My System | Client | My System | Client | My System |
| AAA | AAA# | BBB | BBB# | CCC | CCC# | DDD | DDD# | EEE | EEE# | |
| 11/1/2024 | ||||||||||
| 11/2/2024 | ||||||||||
| 11/3/2024 | ||||||||||
| 11/4/2024 | $600 | $600 | ||||||||
| 11/5/2024 | ||||||||||
| 11/6/2024 | $700 | $700 | ||||||||
| 11/7/2024 | ||||||||||
| 11/8/2024 | $900 | |||||||||
| 11/9/2024 | $900 | |||||||||
| 11/10/2024 | $550 | $550 | ||||||||
| 11/11/2024 | ||||||||||
| 11/12/2024 | $250 | |||||||||
| 11/13/2024 | $250 | |||||||||
| 11/14/2024 | ||||||||||
| 11/15/2024 |
Solved! Go to Solution.
@AgiGovind
Manipulating non-structure data to non-structured data is not really the strong point of Alteryx.
but anyway, maybe we can something as below.

