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).
Thanks for the prompt response. Unfortunately, I don't get any examples for my columns.
I actually want to append a literal string e.g. X000A to an ID (existing field). I can see that I can add a column and then merge with existing column but was hoping that the X000A could be incorporated within an expression.
Similarly, I want to add 0000 to an existing number and then take 4 digits from the right. I can see how the latter would be done using the extract option but don't see where I can incorporate the concatenation of 0000.
Perhaps this is where I need to use the custom calculations?
Thanks for your support.
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).