Grouping columns for output

Hi there,

I'm new to Alteryx. Is there a way to cluster fields belonging to a common group for output to Excel? I want it to look something like this:

So although the fields are defined as Apples, Bananas, etc, they can be grouped together according to whether they are a Fruit or a Vegetable. Is there a way?

Output

Accepted answers

jasperlch

Hi @james204,

If you are going to export the results to excel, I think the closest thing you could get is something like below:

I am afraid Alteryx currently has no functions/tools to control how to merge cells horizontally in excel.

New Workflow1.yxmd

All comments

mbarone

What does the incoming data look like?

james204

Most likely it would be calculated in Alteryx via a Formula tool. Perhaps a more realistic example would be like this:

The key is to get a 'top-level' header name as well as the 'standard' field header.

jasperlch

Hi @james204,

If you are going to export the results to excel, I think the closest thing you could get is something like below:

I am afraid Alteryx currently has no functions/tools to control how to merge cells horizontally in excel.

New Workflow1.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235