I have 2 fields A & B.
I want to use field A if it's not blank.
If field A is blank I want to use B.
Any suggestions on how I could accomplish this? Thanks!
Take a look at #7 in this article.
Unfortunately, they only way i have been able to accomplish that is to do a skip row on the row if Field A is blank to skip row and then process the data with another profile for Field B.