Is it possible to output directly to a text input tool?

Question

Just as the question says, is it possible?

Right now, my workflow involves copying the output from any node using the browse tool and then paste the same to a text input tool for further use downstream which works fine if there are a few tens of rows but when I have upwards of 100, the process is pretty slow and worse when upwards of 1000s of rows.

Hence, I am wondering if I can directly use the browse tool output as text input. Is it possible?

Ben_H · Answer

Hi @HW1,

I suppose I don't quite understand what's being asked here.

I don't understand why you need to copy-paste anything - if you need data from a node upstream, just connect that node directly to the downstream one instead of copying it and inserting a text input.

If this is "general purpose" then any workflow where it happens would do as an example for us to look at.

I assume I'm missing something from your description!

Regards,

Ben

ericsundby · Answer

If this is more of an ad-hoc requirement, then the next best solution would probably be to simply output to an Alteryx database file (.yxdb) and use that as the input downstream.

HW1 · Answer

@ericsundby The goal is to speed up the process and possibly eliminating the copy-paste process as sometimes the use case for a text input tool is warranted. This is a general purpose query hence there is no 'one workflow' I can provide. Generally any node output can be copy-pasted into a text input tool. However, if the records exceed 1000 rows, the process is very slow as Alteryx populates every cell sequentially. I can use the solution that @Qiu provided however, it still is not a very 'automated' process.

@Qiu I use this method currently. Thank you for the quick and unfortunate 😅 resolution to my query..