Hi,
little help on how to do the below:
if a Aerial# contains multiple owners then I would need to create a second row with the same sequence # for secondary owner.
then move secondary owner name from Cost address1 to the payee name column
then move the address from cost address 2 column to cost address 1 column
if cost address 3 contians a value and cost address 2 is blank then
move value to cost address 3 to cost address 2 column
after above default cost address 3 to blank
current:
senk account aerial# date recvd ID payee name cost address 1 cost adddress 2 cost address 3
432 12345 5343 1/1/2023 MULT John Smith mary smith 123 street
desired outcome:
senk account aerial# date recvd ID payee name cost address 1 cost adddress 2 cost address 3
432 12345 5343 1/1/2023 MULT John Smith mary smith 123 street
senk account aerial# date recvd ID payee name cost address 1 cost adddress 2 cost address 3
432 12345 5343 1/1/2023 MULT mary smith 123 street
thanks!
Hi @Hi2023 ,
If you're looking to repeat the header row for each record then you need something a little more complex than simply replacing the values int he rows.
To do this, I've used the Field Info tool to pull the header values into row values, and then a batch macro to apply this for every record.
This identifies those records that have a secondary payee.
This produces the following result:
I've attached the extracted workflow which contains the macro.
I hope this helps,
M.
Its giving an error when I try to open
So mine is not coming out the same---the outcome is showing cost address 3 having a name in the column?
It is also maybe bc some row have adress in address 1, 2, and 3
@Hi2023 ,
Mine is coming out exactly as you posted for the data you provided.
If you have other scenarios can you provide more complex examples so we can provide that?
What is the error you're getting?
M.