How to Copy Values using Specific Conditions?

crazybeauti_ful

Hi,

In the sample below, I need to copy the values of *ABC in Header 2 & Amount IF Header 1 is equal to *DEF - how do I do that? I can't use multi-row because Header 0 can be random in terms of rows placing. Help please.

  Row            Header 0                 Header 1   Header 2    Amount

   12            Account 1                 1 ABC        1 ABC         111.11

   15            Account 1                 1 DEF

   20            Account 1                 1 DEF

   50            Account 1                 1 DEF

   51            Account 1                 1 GHI         1 GHI           222.22

   52            Account 2                 2 ABC        2 ABC          33.33

   55            Account 2                 2 DEF        

   100          Account 2                 2 DEF        

Thank you.

RolandSchubert

Hi @crazybeauti_ful ,

I would consider selecting the source rows to copy using a Filtier tool, joining these rows to the target rows using a Join tool and perform the copy using a formula. I've attached a sample workflow. What do you think?

Best,

Roland

CopyOnConditions.yxmd