Hi Team,
I have following input
i would like merged columns but not rows
both
Trade -cQuantity | Trade - CollValue |
should have merged header as TRADE
BO_ | CUST | ISIN | Trade -cQuantity | Trade - CollValue | Document - PhysicalAmount | Document - Settlamount |
B_R_A | 5B7A | AB123 | 100 | 105 | 110 | 115 |
B_R_A | 5B7A | AB132 | 200 | 180 | 160 | 140 |
B_R_A | 5B7A | AB432 | 300 | 240 | 180 | 120 |
B_R_A | 5B7A | CD455 | 600 | 560 | 520 | 480 |
B_R_A | 5B7A | DS655 | 700 | 450 | 200 | -50 |
Expected output:
column headers
BO_ | CUST | ISIN | Trade | Document |
It's definitely possible to do via a Formula tool - create a new field called "Trade" based on your logic. But I am unsure how you want to combine the values in those fields - I'll leave that up to you.
To do a merged cell though in Alteryx is difficult, and I'd say not recommended as you have to dive into the Reporting tools - you could look at something like this to help out: How to Create Merged Cells in Reports, Part 1 - Alteryx Community