Forum Discussion
Helper IITable.CombineColumns
Hello Experts,
I have the following problem of merging columns.
I'm using Combiner.CombineTextByDelimiter("", QuoteStyle.None), but would likte to see Merged column only with Column B values:
Does anyone have any solution for that?
Thanks in advance!
PQ will always add a custom column at the end. Only option is to reorder the column after the custom column is added. Hence, you will have to select the custom column and drag to an appropriate position. Though you can always merge addition and reordering into one single step.
3 Replies
- Vijay_A_Verma
Most Valuable Professional
In this case, you don't need to use Merge operation. You are just retrieving the value of column B. You should use a Custom column named Merged with following formula
=[Column B]
Dom87326Your right, is it possible to add custom column right after column B? By default they are added at the end of table. I have survey response data, and the layout is important for unpivot transofrmation.
- Vijay_A_Verma
PQ will always add a custom column at the end. Only option is to reorder the column after the custom column is added. Hence, you will have to select the custom column and drag to an appropriate position. Though you can always merge addition and reordering into one single step.