Different output in the alteryx render in the excel file

Hi ,

I would like to ask if we can perform the following in the alteryx:

For instance, I have produced the result 1 (after applying the joining too and other stuff) and in order to produce result 2, i need to do some formularisation to produce it.

However, when i want to export to excel, i want both results presented in the excel as shown in the screesnhot below.

Can alteryx do that ? Could someone briefly explain how should i perform it?

Common Use Cases

Accepted answers

pedrodrfaria

@SH_94

To answer your first question, Yes. When we do not know the quantity of rows, this is when we need to look at the Tables logic as a solution. If we knew the quantity of rows, then we could use the specific range logic.

The second question, No. At least not dynamically like this. Inside of Alteryx you would need to filter out the rows you do not want and then output that. But doing this, the rows you filtered out will never exist in the output file.

What you are looking to do over here is to output like we have talked about, and then INSIDE of excel, you set up that filter. This way the Output file will contain all the data and you will be able to filter out specific data rows.

Let me know if this was not clear.

All comments

SH_94

Hi @ grazitti_sapna

Do you if you can help me on this?

pedrodrfaria

Hi @SH_94

It is pretty simple, the easiest way would be to transform it into Tables and combine them. I have attached an example so you can better understand it.

Pedro.

Different output in the alteryx render in the excel file.yxmd

SH_94

Hi @pedrodrfaria,

Thank you for your response.

Is there anyway to split it ? cz it is two different sets of data and if combine it , i'm unable to differentiate it once exported to Excel.

Or is there anyway not to combine it into table and perform another solutions?

pedrodrfaria

You are not combining the datasets into one. We are transforming them into separate table objects and then combining the tables into a single large table. So the data inside can be different, it does not matter.

The other way, not using the Table logic, would be to Output to a specific range. Do we always know the quantity of rows for each dataset to be outputted?

Pedro.

Different output in the alteryx render in the excel file.yxmd

SH_94

Hi @ pedrodrfaria,

Thank you for your detail explanation. The logic seems to be work in my case.

The quantity of the rows will be different for each data input uploaded. May i know if i still can use table logic in this case?

In addition to that, let use the screenshot example below . After i had created this larger table, will there be any tools or functions that is applicable for filtering both table? For instance, if i want to filter ID A, i will just need to filter it one time at the every top as shown in the screenshot below and the second and third table will follow the filtering exactly.

Let me know if i didnt explain it clearly

Thanks a lot

pedrodrfaria

@SH_94

Let me know if this was not clear.

SH_94

Hi @ pedrodrfaria,

Could you briefly explain the concept / logic on why you need to use the report text and layout function in this case?

SH_94

Hi @ pedrodrfaria,

I not sure what is the purpose of we using these two tools at this moment. Could you briefly explain on this? If we remove these two as per screenshot below, will they have any impact on the excel output?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703