Rows to Columns

WilliamPerrin
WilliamPerrin Member
in Support

Hi,

I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns.

When using the Rows the column, it automatically only finds around 56.

Wondering if anyone else has had a similar issue, and if so, how they went about resolving it.

Kind regards,

Will

Tagged:

Answers

  • James T Sidebotham
    James T Sidebotham Contributor

    Are the 62 rows unique?

  • WilliamPerrin
    WilliamPerrin Member

    Hi James,

    Good idea. There are 2 duplicates which now brings the number down to 60, but there are still some not being pulled through.

  • Josh Boxer
    Josh Boxer Administrator

    Are there more than 5k rows being reviewed for unique values:

    image.png

    If so uncheck the box to confirm you are prepared to wait to get all distinct values

  • WilliamPerrin
    WilliamPerrin Member

    Hi Josh,

    Yes, there are over a million rows. I have tried unchecking that option, but it doesn't work as expected.

Categories