Different output in the alteryx render in the excel file

[SH_94]

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?

[pedrodrfaria]

Using the table, you can have as many rows as you possibly can on each table.

Using a specify range logic for each table, you are limiting to that range the quantity of rows you can input.

Pretty much one gives you as many rows as an excel file has to work, while the other you will be limited to the range you specify.

Hope this helps.

Pedro.

[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?