Forum Discussion
Solved
Concatenate Text Columns into a Single Column
I am trying to combine 3 text columns into a single, "master" column that can more easily be used for search. Example: Table_Contacts Column_SalesRep1 Column_SalesRep2 C...
You could unpivot the 3 columns and get all the values in one column that you could use in the slicer and/or the search column. If you can't do that, you can use SELECTCOLUMNS and UNION to combine the 3 columns into a single column of distinct values.
Regards,
Pat
You could unpivot the 3 columns and get all the values in one column that you could use in the slicer and/or the search column. If you can't do that, you can use SELECTCOLUMNS and UNION to combine the 3 columns into a single column of distinct values.
Regards,
Pat