Hi ,
Is there any way to concatenate the values available in multiple row of a given column using Multi row formula expression .
Thanks
Here is the expectation :
CC | Vend | Dtype | Result |
A | V1 | 92 | 9282 |
B | V2 | 11 | 11 |
A | V1 | 82 | 9282 |
Hi @binuacs ,
Thankyou .Just a small change . Can you help to arrive the result based on uniqid as shown :
CC | Vend | Uniqid | Dtype |
A | V1 | AV1 | 92 |
B | V2 | BV2 | 11 |
A | V1 | AV1 | 82 |
@Nandakishore I updated both my workflows, i was using a wrong field iin the initial workflow
Hi @binuacs ,
Thanks again . I applied below formula in the tool :
IIF(isNull([Row-1:Uniqud]) AND isNull([Row+1:Uniqud]),[DType],IIF(isNull([Row+1:Uniqud]),[Row-1:output],(toString([DType])+toString([Row+1:DType]))))
and the result is :
VSR_Uniqud | DType | output |
FR463791776328472024 | RE | RE92 |
FR463791776328472024 | 92 | 9286 |
FR463791776328472024 | 86 | 9286 |
But i need like this :
VSR_Uniqud | DType | output |
FR463791776328472024 | RE | RE9286 |
FR463791776328472024 | 92 | RE9286 |
FR463791776328472024 | 86 | RE9286 |
Do you have to use the multi-row formula tool? This would be much easier using a summarise tool. Group and concatenate the values you want (removing separators from the concatenation) then join back on to the original data.
Obviously you can use whichever tools you like, but you shouldn't get duplication joining back the summarised data, see my output above.