Forum Discussion
Conditional logic help for integer and character?
Hi! This sounds like a simple fix but I can't find the solution anywhere. I want to write a conditional if statment based on the machine codes in our plant. For example if the machine code is a n...
Anonymous
Try as a new column in Power Query, Adjust your Column Name, mine is Custom=Value.FromText(Text.Start([Custom],1)) is number and Value.FromText(Text.Middle([Custom],1,1)) is text________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Fowmy
Super User
Super UserAnonymous
Try as a new column in Power Query, Adjust your Column Name, mine is Custom
=Value.FromText(Text.Start([Custom],1)) is number and Value.FromText(Text.Middle([Custom],1,1)) is text
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂