We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Finding Specific Value of a column need to set marker in a new column till the row contain

Mehedi
6 - Meteoroid

Hi 

 

Seeking support for a problem statement. Sample data set given in the attachement

 

Need to add Asset and Liability in marker column. 

 

"Asset" would be till the "Total Asset" Row and "Liability" would be till the "Total Liability" of the column 

1 REPLY 1
OTrieger
13 - Pulsar

@Mehedi 

You can do it in many different ways.

One way will be with multi row tool, get Assets and Liabilities and then fill in the data in

Another way will be to split the data after Total Assets with a filter tool and then add with simple formula tool Assets to one side and Liability to other side and union the data back

Another way will be to add RecordID get the number for Total Assets and then append it back, and do a simple formula that checking if the number is equals or smaller than it then Asset otherwise Liability and the list is long on the additional ways on how you can do it. So select that one the fit you.

Labels
Top Solution Authors