Equivalent of looping?

Question

I have looked at a couple forum posts on here about equivalent examples to a nested for loop/conditional loop, but I can't get the exact answer I am looking for.

I am trying to compare a specific datetime from an individual row in a table to a datetime value in all the other rows in the table with the same unique key value. I want to do this for every row in the table, so I would be looping through every row in the table ONE time for EVERY row, in other words a nested/double loop. My question is would this accomplished using one of the macros? Or could I get along without those tools?

I am new to alteryx, so thank you in advance :)

Tanai_Goncalves · Answer

Hello,

not sure about dataset size, but for a small dataset, you could split your workflow grouping by the date you want find, and then join together the grouping results and real data using the “Append Field” tool. Later is just filtering dates.

fleenorg · Answer

Dan,

Attached is an example of what I am working with.

Data like this would be inputted. To be more specific about my problem, I want to look at the transactions for each account and see if any account has transactions being made on a monthly basis. The amount doesn't need to the exact but it should be similar.

The output would be a new field that is just true or false if that transactions happens at least 1x per month.

Let me know if you have any other clarifying questions.

Thanks,

Geoff

Book1.xlsx

danilang · Answer

hi @fleenorg

The answers to "My question is would this accomplished using one of the macros? Or could I get along without those tools?" Are Yes and Maybe.  What type of macro to use in the 1st case and how to determine if you can do it without a macro, depends on the data that you're using and exactly what you want to accomplish.  If you join the two tables on unique key, you can then compare the timestamps from the first table to all the timestamps in the second.  This may be all that's required to solve your problem, but we need to know more details about what you need to do.

Can you provide some sample input data, details about the comparison process and the corresponding output?

Dan