We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

Reporting Tool : Unable to align multiple Tables

GayatriPanigrahi
7 - Meteor

Hi All,

 

I have 3 table and need to align each on another as per attached image

Attached workflows has created but facing issue while aligning the table, i tried to find solution for this in community but couldn't get the resolution.

 
8 REPLIES 8
RobertOdera
12 - Quasar

Hi, @GayatriPanigrahi 

 

This is what you need.

Approach notes to follow in 15 minutes or so...

RNO2_0-1590084608839.png

 

RobertOdera
12 - Quasar

Hi, @GayatriPanigrahi 

 

Please mark as an acceptable solution + Like, if this works for you.

 

Solution result

RNO2_0-1590084707991.png

Workflow

RNO2_1-1590084754879.png

 

Rationale

Consideration logic for your tables (I will solve for the first Basic table, and you can repeat the approach for the remaining basic tables)

 

Step1

-You have four columns: Product, Name, Qty, and Amount

-for the first column, Product, set width = Fixed, 2 inches; Alignment (H) = Left, Borders = None

-for the remaining columns (deduced based on the image that you shared) set widths = 1 inch; Alignments (H) = Right, Borders = None

- so now you have four columns with widths 2,1,1,1 therefore set Table Width = 5 inches (see snippet below)

RNO2_2-1590084983246.png

 

-To align all other tables, make sure that the first column for each of those tables matches the basic table config for the first column of the first table.

-Match subsequent basic table configs for subsequent columns to the basic table config for the subsequent columns of the first table

 

Step2

Configure the Layout Tools connected to the Basic Table Tools per snippet below (again based on what you already had).

RNO2_3-1590085607143.png

 

Step3

Use Multi-Join versus union (because you need, in your case, the three outputs versus one amalgamated output).

Muti-join on Position per snippet below

RNO2_4-1590085775975.png

 

Step4

Configure the Layout Tool that's connected to the Multi-Join tool per below (notice the three outputs!).

You can order them according to how you want them rendered (first, middle, last).

RNO2_5-1590085932823.png

 

Step5

Configure the Render Tool per snippet below.

RNO2_6-1590085992976.png

 

Workflow also attached here.

Cheers!

GayatriPanigrahi
7 - Meteor

Hi @RobertOdera ,

 

That is great stuff.

I followed the instruction and column width but when i run the workflow column-A,B get merged for 2nd table and column-A,B,C get merged for 3rd table.

I am using version - 2018.4

 

AlteryxOutput.JPG 

deviseetharaman
11 - Bolide

Hi @GayatriPanigrahi 

 

Could you please something like the one attached. It works best for pdf.

GayatriPanigrahi
7 - Meteor

Hi @deviseetharaman ,

 

You are correct It works in PDF

But the requirement is to get the same format in excel, and when i try to export in excel the columns get merged automatically

RobertOdera
12 - Quasar

Hi, @GayatriPanigrahi 

 

Sorry to hear that.

Yes, I now see that the browse tool result is not replicated in the excel render (my bad!).

 

Kindly consider the following:

1.  run the prior workflow, but change the final Layout Tool "orientation' setting to Vertical with Section Breaks.

This will generate an Excel file with three tabs (each input source will output as a separate tab).

And then you can run a secondary regular flow to union the tabs into one sheet.

 

2. run this updated workflow.

It is a bit manual-messy because I seed pad columns to match the # of columns in the source with the most columns.

I used underscore pads to minimize optics (but it is still messy).

However, you can run a secondary flow on this as well (add row record ID, identify rows with headings, replace underscores with blanks).

 

By the way, I also wrote you a process using the Union versus Multi-Join, if you're partial to Unions.

 

I hope this helps and I hope the Community picks this up as I'm sure there's a proper solution here (even if we have to Macro it out!).

 

RNO2_1-1590156522267.png

 

 

RNO2_0-1590156497977.png

 

 

GayatriPanigrahi
7 - Meteor

Hi @RobertOdera ,

 

You have created dummy columns to have same number of column in all tables which will result same layout but is not feasible solution in real case as i have more then 50 columns.

RobertOdera
12 - Quasar

Sure thing, @GayatriPanigrahi 

 

Some gentle feedback:

1. Kindly spend a little more time providing details when you post for help.

Got it, your actual use case needs to handle a huge number of columns (and probably do that dynamically) + output per your initial posts.

 

2. Thanks for staying engaged and for your clarifying responses!

 

Okay, let's get back to it!

 

Solution output

RNO2_0-1590260745699.png

 

Alter workflow

 

Everything on the left of the Reporting Tools is my brute-force approach, which should handle your requirements as I now understand them. Please pay attention to the documentation (there are few quirks that I've treated for and commented on for your convenience). Please also note the configs in the Reporting Tools (for example, I have Row Rules logic in the Basic Table).

 

RNO2_1-1590261033987.png

New Alter workflow attached.

Again, it's a brute-force attempt because I'm at diminishing return, but first we make it work, and then we make it better!

Cheers!

 

Labels