concatenate data

[jwi1]

Good day,
I am looking for a solution for the following.

Below is a simple table with container_nr, counter and rep_code.

Container_nr HLXU8713416 has 2 rep_codes, HLXU8737594 only 1.

The outcome of the formula I am looking for is displayed in de column OUTCOME.

So, as HLXU8713416 has 2 rep_codes, the outome starts with "2", after that the rep_code of that particular line in the dataset is mentioned.

HLXU8737594 has only 1 rep_code, so it starts with '1', and after that de rep_code.

Thanks for your advise!

John

container_nr	counter	rep_code	outcome
HLXU8713416	1	E49 1 RN 26	2 E49 1 RN 26
HLXU8713416	1	E51 50 RN 26	2 E51 50 RN 26
HLXU8737594	1	E49 1 RN 26	1 E49 1 RN 26

[amitchandak · Accepted solution]

@jwi1 , Try a new column like

countx(filter(Table, [container_nr] = earlier([container_nr])),[container_nr]) & " " & [rep_code]

[jwi1]

Brilliant!

Thanks a lot.

John