Select all combinations of rows

Question

Dear community,

I have 401 rows of data and I need to run a macro on every combination of 5 on the data (82 billion loops).

So, I'm wondering if there's a way to select 5 rows out of 401 these 82 billion times to do that.

I thought I would prepare a csv file with 401 x 82 billion matrix of 0-1 where sum of ones in a column = 5. Then select first column from the matrix, inner join with the data, filter where values in column = 1, run macro, select second column from the matrix etc...

If I follow my way, is there a way to dynamically select column 1 by 1 in Alteryx?

Best,

Wiktor

w_zielinski · Answer

Hey, thanks for the advice.

The problem is still, that I have a csv with 82 billion columns, so Alteryx won't make it technically.

Can I somehow input csv columns one by one? So, Alteryx won't have to input a huge csv file at the beginning, just input first column, then second, then third etc...
Or, I can save 82 billion csv files with 1 column. Is there a way to dynamically input them 1 by 1 in Alteryx with every macro iteration?

IraWatt · Answer

@w_zielinski  Yeah that should increment through each column on each iterative loop starting with the first column

w_zielinski · Answer

Hey, thanks for the reply. So if I select [FieldNumber]=iterative parameter+1, then I should be able to select columns dynamically with every macro iteration?