Concatenation of Values in Rows

[Nandakishore]

Hi ,

Is there any way to concatenate the values available in multiple row of a given column using Multi row formula expression . 

Thanks

[Nandakishore]

Here is the expectation : 

CC	Vend	Dtype	Result
A	V1	92	9282
B	V2	11	11
A	V1	82	9282

[binuacs]

@Nandakishore 

[Nandakishore]

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

[binuacs]

@Nandakishore I updated both my workflows, i was using a wrong field iin the initial workflow

[Nandakishore]

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

[Christina_H]

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.

[Nandakishore]

@Christina_H ,

When i join back the line duplicate  hence multi row formula 

[Christina_H]

Obviously you can use whichever tools you like, but you shouldn't get duplication joining back the summarised data, see my output above.

[Nandakishore]

@Christina_H ,

thankyou . I like to see this with multi row formula .