I am trying to filter some contracts that are over 10000 items, there is a cap on the text input icon, is there any way to surpass this total so I can pull a full range of contracts for analysis?
@jennifer_aulet If you have 13 files, you can use * in your input tool like \\myserver\myfolder\myfile_2022*.csv or you can use 13 input tools+union tool after
Hello @jennifer_aulet Not sure to understand. Can you show your workflow please?
@jennifer_aulet
I'm not sure I understand. If you export all of items contract in excel sheet and then import this excel in alteryx for analysis, it doesn't work?
@jennifer_auletWell, ok, it's indeed limited and you can read https://help.alteryx.com/20221/designer/text-input-tool on how to turnaroundHowever, maybe a text input is not the good tool to use. Where did you find this contract numbers ? I would use a classic input tool with a file (excel, csv or whatever)/table in a base instead.
I can get the workflow to work, but it does not seem to pick up all the data for the open item id in the filter. the amount pulled seems too small considering the number of open items in the selection. I have 124026 items in the selection
@simonaubert_bd i have the items I wanted filtered saved as a CSV file and that seems to pull in but it is limited on the 10000 item cap. I just cannot seem to find a way to manually add the items I would like to filter w/o the workflow crashing.
@jennifer_aulet Regardless of the import or copy/paste method you use, the Text Input tool will only allow a maximum of 10k records per import/paste. You'll need to do it multiple times if you have 124k records. The more efficient way to pull in your 124k records is to:
Please mark this as a solution via Like if this solves your issue.
@jennifer_aulet Yes, the csv with an input tool will import all the rows, it works even with millions of rows..
@gyang3 thank you for this information, is there a way to have multiple text inputs to combine with a filter?
Say I split the items to filter by 13, would I be able to use 13 input text icons and have them filter through selections?
