How can we help you today? How can we help you today?

setting multiple columns at the same time

This may be tricky to implement but I have a table with 30 columns that are all INT and should have values between 1 and 10 to store survey responses. Is it possible to select all these columns in the SQL Data Generator UI and set them all to be RegEx [0-1][0-9] in one step?
fatherjack2
0

Comments

3 comments

Sort by
  • Anu D
    Many thanks for your post.

    Yes you can do that but it will do it in batches of 10.

    To do that you need to follow below mentioned settings:

    You have to select them one at a time and set there Min value as 0 and Max value as 9 and than set the distribution as 'Random'

    Kindly let me know if this answers your question.

    Mean while I will try to find best way to do it.
    Anu D
    0
  • fatherjack2
    Anu, I can get the values in to the columns fine, its just I have to do it 30 times. The feature I am asking for is to be able to select more than one column and apply the same data generation rules to them all.
    fatherjack2
    0
  • Anu D
    Many thanks for your e-mail.

    We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SDG-908.

    It will be reviewed by product manager and than marked for the next release.

    I will update you as soon as it is incorporated.
    Anu D
    0

Add comment

Please sign in to leave a comment.