Pivot table with 1M records

I have a table of multiple URLs to one ID…the table has about 1.5 million rows. I’m trying to pivot the data so that each column is URL 1, URL 2, URL 3 and on…so I have one row for each ID.

When I try to do a pivot it tells me that my table is to big, there is a 100,000 row limit. Anyone know of any other way to do this?

Can you please post a screenshot of the action settings and the error?

Nevermind I figured it out…I was trying to put the 1M records as columns, I was misunderstanding the action settings.

1 Like

Great! Thank you for the update.