Macro/Batch Macro

Question

Hi everyone,

I have 2 tables [Raw] and [Totals]. Both contain same field structure, ID and Account , but in [Raw] table, field Account is not populated. And I want to do this based on values from [Totals] table.

Based on ID field values comparison of 2 tables , I want to populate Account field in [Raw] using that sequence :

IF ID[raw]<ID[Totals]

Then

Account[Totals]=Account[Raw]

Very important is that comparison should be done always for remaining items in both tables at each loop run.

I am new in Alteryx and any idea will help me to fix this issue.

Many thanks

Best regards

Florin

New.yxmd

Florin · Answer

Many thanks @atcodedog05 . That's fantastic !😊 Lots of thanks.

atcodedog05 · Answer

Hi @Florin

Based on your expected output and logic here another way of doing it. Check for your scenario and see whether it works.

Workflow:

1. Union raw and total.

2. Sort them descending by ID. The reason is lower ID will need to take amt from higher ID.  ID[raw]<ID[Totals]

3. Using multi-row formula tool to fill out lesser ID's which are null with higher ID amt. This cover 2 logics

* Exhausting the list on each total ID
* Applying logic IF ID[raw]<ID[Totals]

Then

Account[Totals]=Account[Raw]

4. Sorting Id on ascedning.

Hope this helps : )

IDs.yxmd

Florin · Answer

Ok. Sure. Apologize for late reply.

Output.xls

raw.xls

totals.xls