Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data formatting

satya04
8 - Asteroid

Hi, the image from Alteryx needs to be converted into the format that is presented in the below screenshot from excel. I wont need the formatting in black but I would like to have the data being split for the purpose of preparing charts from the data. Please suggest the approach in this regard.

 

satya04_0-1678461523876.png

satya04_1-1678461540940.png

 

3 REPLIES 3
Christina_H
14 - Magnetar

I think the simplest approach would be to create tables in Alteryx and lay them out vertically before rendering into Excel.  That could also include the black headers.

satya04
8 - Asteroid

Can you please elaborate? And all the metrics need to be on the same sheet.

Christina_H
14 - Magnetar

Something like this (figures are made up)

Christina_H_0-1678468362472.png

Christina_H_1-1678468374934.png

You technically don't need the layout tool, you can attach the header directly to the table, but that leaves an empty row between table and header.

Labels
Top Solution Authors