Szymon Mon Posted November 25, 2019 Share Posted November 25, 2019 Hi, My sample data looks like: Project | Group | Date | Values_to_concatenate ------------------------------------------------------------------- Project1 | AA | 07-2019 | abc Project1 | AA | 08-2019 | cde Project1 | AA | 09-2019 | qwe Project1 | AA | 09-2019 | asd Project1 | AA | 10-2019 | zxc I would like to create new column which allow toachive the following result: Project | Group | Date | New_Values ------------------------------------------------------------------- Project1 | AA | 07-2019 | abc Project1 | AA | 08-2019 | cde Project1 | AA | 09-2019 | qwe, asd Project1 | AA | 10-2019 | zxc Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted November 27, 2019 Share Posted November 27, 2019 You can use pivot transformation. Data > Transform Data > Pivot > Select first 3 columns as Row Identifiers > Select last column in Values section and select Concatenate or UniqueConcatenate aggregation so rows with first 3 column values same will be merged in to one and last column will be concatenated. Doc: Pivot data https://docs.tibco.com/pub/sfire-analyst/10.6.0/doc/html/en-US/TIB_sfire... Link to comment Share on other sites More sharing options...
Antonio Martinez Posted November 22, 2023 Share Posted November 22, 2023 it works with the original columns but how to do the same using some calculated columns ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now