Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Force the data type of every field in a Select Tool

PhilipMannering
16 - Nebula
16 - Nebula

Hi All,

 

To create repeatable results, I often find myself forcing the data types of every field.

image.png

 

But there could be hundreds of fields. Is there a quick way to change the data type to be forced for every field? I can't think of one, other than editing the xml or a .yxft file to have Forced = "True" for every field.

 

TIA,

Philip

1 ANTWORT 1
gawa
16 - Nebula
16 - Nebula

hi @PhilipMannering 

I could not come up with one other than xml or yxft, either, so I prepared WF to modify .yxft file.

First, please extract .yxft file form your target Select tool, and load it into this WF and run, then you will get a new .yxft file having "forced=True" tag for all of fields, that will be loaded to your target Select tool.

At least it worked at my computer. Hope this would help you.

image.png

Beschriftungen
Top-Lösungs-Autoren