Pivot table with 1M records

#1

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?

#2

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

#3

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

1 Like
#4

Great! Thank you for the update.