This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
Different output in the alteryx render in the excel file.yxmd
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.
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.