As a part of my job (internal audit) i make a procedure to detect jounals entries that not be part of the period. It because the information sistem not control it
So How can I find this outliers using Alteryx.
Jounal Number | January | February |......... |July |.................|December| |Check|
1 1 Ok
2 2 Ok
3 3 Ok
4 4 Ok
5 5 Check, it corresponde to january Seq
6 6 Ok
7 7 Ok
8 8 Ok
9 9 Ok
10 10 Ok
11 11 Ok
12 12 Check, it correspond to February Seq
13 13 Ok
16 16 Ok
17 17 Ok
18 18 Check, it correspond to February Seq
19 19 Check, it correspond to February Seq
20 20 Ok
23 23 Ok
24 24 Ok
27 27 Ok
29 29 Check, it correspond to July Seq
33 33 Check, it correspond to July Seq
36 36 Check, it correspond to July Seq
37 37 Ok
39 39 Ok
40 40 Ok
.
.
.
.
65000
