How to handle a table with more than 500 columns using 'rows to columns' object?

mdykman
mdykman Member
in General

Right now, 'rows to columns' object retrieves only 100 rows.

Best Answer

  • Josh Boxer
    Josh Boxer Administrator
    edited February 10 Answer ✓

    Hello it is possible to update the 100 column limitation if needed, but note the warning about potential performance degredation.

    "By default, up to 100 new columns are allowed, the first 5,000 rows will be sampled, and the timeout is 10 hours. You can change these defaults in the server.properties file. Note that changing some of these values may affect Data Studio performance."

    https://docs.experianaperture.io/data-quality/aperture-data-studio/objects/workflows/#rows-to-columns~workflow-steps

    By default your Server.properties file would be found in the installation directory C:\Program Files\Experian\Aperture Data Studio <version>. Once you have updated the file you will need to restart the Server

Answers

  • mdykman
    mdykman Member

    Thank you. We'll look into it. We find work around, using Sample step.

Categories