Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Is there a fast way to use the Auto Field tool result to put in Select tool?

LauChuanLi
5 - Atom

Is there a fast way to use the Auto Field tool result to put in Select tool? to change the data type and size to improve performance instead of manually copy the result from the Auto Field tool to Select tool. 
I realized that the conversion process from Auto Field is slow. 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

I think this should work.

 

1. Add the Auto Field Tool → Select Tool.

image.png

2. In the Select Tool Configuration > Options > Save/Load > Save Field Configuration > Save the a yxft file.

image.png

3. Delete and connect around the Auto Field Tool

4. In the Select Tool Configuration > Options > Save/Load > Load Field Names & Types > Load the previously saved yxft file

 

 

PhilipMannering
16 - Nebula
16 - Nebula

Hi @LauChuanLi. Did this solution work for you? Even if you didn't use it, I believe this to be a (relatively) fast and effective way to use the AutoField settings in a Select Tool - therefore please mark as a solution.

Labels