Batch macro

Question

Hi,

Wanted to see if this can be done using batch macro?

As seen in below snapshot, there are some empty values. I need to see if sf first name is empty and first name not empty and vice versa and return review if true else good. Likewise do the same check for last name. So imagine I have 30 rows with all these columns and need to keep doing this check for every record(row) and return the status as review or good. Wanted to see if this can be done using batch macro?

Qiu · Answer

@aparna0208 
I think we can use the Transpose and Cross Tab tool for this kind of issue.

1013-aparna0208.yxmd

aparna0208 · Answer

@Alayna Thank you for your response! I already tried it with formula tool but this is just sample data. I have about 20+ columns so using formula for each and then to union all output might not look good. So just trying to use if this can be accomplished using macros.

Alayna · Answer

Unless I'm misunderstanding it sounds like you can just use a formula tool, which will apply the same logic to all of your rows.

if isempty([sf first name]) and !isempty([first name])

then 'Review'

else 'Good' endif

if isempty([sf last name]) and !isempty([last name])

then 'Review'

else 'Good' endif