Forum Discussion
Changing the format of values
No. You will need to pre-split the first list so it is John Doe and the second so it is Doe John - all in separate columns, then merge the columns back in the correct order.
For the first transformation select the column, go to Transform, then select Split Column, and select from Lower to Upper Case.
It becomes this
If you want it to be Lastname, FirstName, then just merge those:
Select Column1.2 first, then Column1.1, then on the Transform ribbon, Merge Columns, then use this setting:It becomes this:
The problem will be with names that have multiple case transitions. JohnDoe is simple. JeffMcAllister is not. It will get split into 3 columns.
Community ChampionNo. You will need to pre-split the first list so it is John Doe and the second so it is Doe John - all in separate columns, then merge the columns back in the correct order.
For the first transformation select the column, go to Transform, then select Split Column, and select from Lower to Upper Case.
It becomes this
If you want it to be Lastname, FirstName, then just merge those:
Select Column1.2 first, then Column1.1, then on the Transform ribbon, Merge Columns, then use this setting:
It becomes this:
The problem will be with names that have multiple case transitions. JohnDoe is simple. JeffMcAllister is not. It will get split into 3 columns.