Combining of multiple reports into single report along with report title

[Gsiva3]

Hi Team,

I have one workflow with 3 separate processes. for each process I have one unique report, My concern now is to combine all these 3 reports into one report with Report name as Title in the report. I have attached the sample input & workflow.

If input filename of 1st part of the workflow is "Input 1" then the report title should be "Input 1"

If input filename of 2nd part of the workflow is "Input 2" then the report title should be "Input 2"

If input filename of 3rd part of the workflow is "Input 3" then the report title should be "Input 3"

So now all I want is Need all these 3 these reports with the title as mentioned above in a single report.

Is there any method to do this so?

[grchavarri]

Hi @Gsiva3 

There's a lot of ways to solve, depending on which positions do you want the reports and the tables.

I have found a way but I don't know if it works for you. See attached images. I have used the append tool to put one table next to each other, and you get that result. 

Probably if you use a union tool in the middle, putting the tables one below the other, you will get a different result, but i dont know if its the case. 

let me know if it helps or any doubts

Best,

[mathieuf]

Hi @Gsiva3,

Have a look at the attached workflow.

Does that answer your need?

[Gsiva3]

Hi @mathieuf 

Since I am using a older version, not able to open the package what you have sent.

Can you please send it in a general workflow format

[Jonathan-Sherman]

Hi @Gsiva3,

Which version of Alteryx are you using?

Kind regards,

Jonathan

[Gsiva3]

Alteryx Designer 2020 version

[Jonathan-Sherman]

Hi @Gsiva3,

I've saved @mathieuf's file as an older version so you should be able to download the attached!

Kind regards,

Jonathan

[Gsiva3]

Hi @Jonathan-Sherman 

Thanks for the support

Hi @mathieuf  @Jonathan-Sherman 

This is the what the way I wanted, 3 reports each in separate sheet in PDF file. But I need the report name in top of the each page, say for example in page 1 I want the title as Input 1, in page 2 I want title as Input 2.

Is there a way to do this ?

[mathieuf]

@Gsiva3 

Of course! 😉

Have a look

[Gsiva3]

Hi @mathieuf 

I am getting below mentioned error.