This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to join two simple tables (with no join field), I just want it populated in the first line it sees a new ID
I have a table that looks like below
and I have another value in another table that is just like this
I want my output to look like below,
here is a quick way to do it:
1) I joined the amount to EVERY row using the Append Fields Tool.
2) I use a Multi-Row-Formula to replace it with 0
3) I replace 0 with Null() using a simple Formula [I can't do this before, because I check if the values are null to find the first row)
I'll attach my workflow. Let me know if it helps.
@grossal what if they are not sorted and I do not want to sort them?
Add a Record ID, sort them, follow my attached workflow above, and resort them to record numbers. This way you keep the original sort.