Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

set a value based on another column

david20100
8 - Asteroid

Hi,

 

When in Column WarrantyOK i have an invoice number + TG (for example A76541TG) the ledger associated to that invoice is 630000.  The 2 other lines have different ledger.  I want all lines from the same invoice to have the ledger from column chanumTG

 

In that case those 3 parts should have 630000 in chanumTG

pnumpnom1WarrantyOKParts or ClaimfdglvenchanumchanumTGchanumbooleen
470028VALVE A GAZ RESERVOIR 25 LITRESA76541TGCLAIM300652300652 VRAI
TG-ENRORÉPARATION/GARANTIE ENROA76541TGCLAIM630000630000630000VRAI
TRANSPORTÀ DÉTERMINERA76541TGCLAIM300752300752 VRAI

 

Thanks

3 REPLIES 3
nick_ceneviva
11 - Bolide

The attached simple workflow could be added to your workflow to get the proper ledger number.  The important part is sorting by the Warrant field and then the chanumTG field in Descending order, so nulls are last. 

 

Then use the multi-row formula tool to update ChanumTG.  You should Group by Warranty, set it to you the closest valid row and the formula should be [row-1:chanumTG]

david20100
8 - Asteroid

Thanks for the fast answer Nick.  I have version 11.0.6.28907 and if i do check for updates - no updates available.  I cannot open your file it says its been created by a more recent version

 

thanks

Edit: Nevermind there's 11.5 on the website i will install that one and keep you posted

david20100
8 - Asteroid

Works perfectly

 

thanks

Labels