Hi, I was starting in Alteryx and I have a question.
I wanted to create a Macro that would scroll through a table with a "dynamic loop", for example:
Table A:
| DATE | HOUR | NUMBER |
| 23/03/2020 | 07:30:00 | 3 |
| 23/03/2020 | 08:30:00 | 2 |
| 24/03/2020 | 08:30:00 | 4 |
| 25/03/2020 | 07:30:00 | 5 |
| 25/03/2020 | 08:00:00 | 2 |
| 26/03/2020 | 07:30:00 | 6 |
| 26/03/2020 | 08:00:00 | 2 |
Table B:
| ID | DATE | HOUR |
| 1 | 23/03/2020 | 07:30:00 |
| 2 | 23/03/2020 | 07:30:00 |
| 3 | 23/03/2020 | 07:30:00 |
| 4 | 23/03/2020 | 07:30:00 |
| 5 | 23/03/2020 | 08:30:00 |
| 6 | 23/03/2020 | 08:30:00 |
| 7 | 23/03/2020 | 08:30:00 |
| 8 | 23/03/2020 | 08:30:00 |
| 9 | 23/03/2020 | 08:30:00 |
| 10 | 23/03/2020 | 08:30:00 |
Table Result:
| ID | DATE | HOUR | Y/N |
| 1 | 23/03/2020 | 07:30:00 | Y |
| 2 | 23/03/2020 | 07:30:00 | Y |
| 3 | 23/03/2020 | 07:30:00 | Y |
| 4 | 23/03/2020 | 07:30:00 | N |
| 5 | 23/03/2020 | 08:30:00 | Y |
| 6 | 23/03/2020 | 08:30:00 | Y |
| 7 | 23/03/2020 | 08:30:00 | N |
| 8 | 23/03/2020 | 08:30:00 | N |
| 9 | 23/03/2020 | 08:30:00 | N |
| 10 | 23/03/2020 | 08:30:00 | N |
....... (others days)
Relate by date and time and create Y/N.
Notice that the Y appears referencing the quantity in table A... If the quantity is greater than the number in table A, the N appears in the remainder.
Your collective help in setting me straight would be appreciated.
