set a value based on another column

david20100

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

pnum	pnom1	WarrantyOK	Parts or Claim	fdglven	chanum	chanumTG	chanumbooleen
470028	VALVE A GAZ RESERVOIR 25 LITRES	A76541TG	CLAIM	300652	300652		VRAI
TG-ENRO	RÉPARATION/GARANTIE ENRO	A76541TG	CLAIM	630000	630000	630000	VRAI
TRANSPORT	À DÉTERMINER	A76541TG	CLAIM	300752	300752		VRAI

Thanks

For-Alteryx.xlsx

Service-ClaimsTest.yxzp

nick_ceneviva

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]

setvalue.yxmd