Forum Discussion
Custom columns in DataFlow Gen2
1. Can you clarify what do you mean by "I don't get any examples for my columns" - do you mean you provided the examples but it didn't work?
2. Extending current string value with a suffix can be done by clicking Format -> Add Suffix
Doing "Add Suffix" to a number column will actually convert it to text first, and then do the literal append of "0000" - at that point your number loses their numerical meaning and are simply textual. Perhaps this is what you wanted to do, perhaps there are numerical ways of achieving this.
Adding column from example does not change existing columns in place. However, you can do the same by adding the column first, then dropping the old column(s).
Concat two columns:
Select the two columns and click Transform -> Merge Columns
To cleanse the column, use Transform-> Extract
Finally, something like this is perfect candidate for Column from Example:
Give it a try - type out a few examples of what you want the output to be, and the UI should figure out how to do this effectively.