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

Populate Based on Another Field

Hi,

I have five address fields (addr1,2, 3 etc.) and for the first line I am only populating it with a value 50% of the time.

What I would like to do is only populate addr2, 3, 4 and 5 if addr1 has a value.

Not sure how to go about this?

Thanks


Gary
garyk1968
0

Comments

3 comments

Sort by
  • Andrew P
    Hello Gary,

    Thanks for posting your query!
    I am sure that you have taken a look at our documentation, but in any case here is the link to that http://documentation.red-gate.com/displ ... tgenerator

    I will be following up with you via email to hopefully help you out!

    Warm Regards,
    Andrew Pierce
    Redgate Support Engineer
    Andrew P
    0
  • moody31415
    I'm looking to do something similar and I'm also having difficulty. Can you post the solution here?
    I'm also having trouble because the python sample scripts only show samples for columns without spaces in their names. How do you handle a column that has spaces? http://documentation.red-gate.com/displ ... on+scripts
    moody31415
    0
  • moody31415
    Ah I figured it out - spaces are just removed in column names.
    moody31415
    0

Add comment

Please sign in to leave a comment.