Hello community!!
Would appreciate any help for the below problem since I could not find any similar questions on the community.
I am trying to concatenate the description values as shown in input screenshot below to reach the output screenshot. It is not always the same spacing between the amounts.
Input:
Output:
Solved! Go to Solution.
Hello @cycyg
There are two ways that come to mind to solve this. Depending on the rest of your dataset, choose whichever one fits your needs the best.
1. Use a multi-row formula tool to update the Amount field to "fill down" the missing values with this expression:
iif(isempty([Amount]) && [Value]=[Row-1:Value] && [Type]=[Row-1:Type], [Row-1:Amount], [Amount])
Then use a summarize tool to concatenate the description field and group by the rest.
2. You can use a summarize tool to concatenate the description field, take the first for the amount field, and group by the rest.
hey @cycyg
You can achieve this with the summarize tool:
(Slightly mis-ordered)
Please find attached: