Populate Based on Another Field

garyk1968

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

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

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

Ah I figured it out - spaces are just removed in column names.