Forum Discussion
Angith_Nair
Continued Contributor
Continued ContributorAdd Column using column from examples.
Hello team,
I just want to convert values in the form which is shown below...
Here "Column" is a raw column and I want to convert the values like "Custom" column. Basically what I want is If Column has values that are in pattern "T6H5N6" then I want the first 3 characters which will be "T6H" and if the values are purely numeric i.e "235875" then I want that value as it is. Please note that the length of the characters/numbers is 6 which is constant. How can I acheive this in Power Query?
Thanks in advance.
Angith_Nair
Add the following as a Custom Column:=if Value.Is(Value.FromText([ABC Custom]), type number) then [ABC Custom] else Text.Start([ABC Custom],3)
2 Replies
- Fowmy
Super User
Angith_Nair
Add the following as a Custom Column:=if Value.Is(Value.FromText([ABC Custom]), type number) then [ABC Custom] else Text.Start([ABC Custom],3)
Angith_NairHi Fowmy ,
That worked....thank you so much...I really appreciate it...