Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

What does %User.DevLimitLongTables% mean

MartWClimber
9 - Comet

Hello,

 

I´m looking at an .yxdb table that doesn´t want to load and i´m seeing a for me new Record-limit value.

Does anybody at the community know's what  %User.DevLimitLongTables% means?

 

MartWClimber_0-1637223213898.png

 

1 REPLY 1
danilang
19 - Altair
19 - Altair

Hi @MartWClimber 

 

This syntax refers to user-defined variables defined in the workflow config.   They're called variables, but they act as constants, since there is no way modify them from within the workflow.

danilang_1-1637504483709.png

 

 

You can use them almost anywhere in tool configs or formulas using the "%User.VariableName%" syntax.  Any time the runtime engine see a reference like this, it's replaced with the value defined in the config. 

 

In your case, it's used to add a configurable upper limit to the number of rows that are read by the input. In the attached example, the variable is used to limit the rows read by the input tool.  The csv contains 3 rows, and by changing the variable, you change the number of rows that are read.     

 

As to why it's there, the original author of the workflow might have wanted a quick way to limit rows so the workflow would run faster during development.  In production, changing the value to very large number will read the entire file. 

 

Dan

 

  

Labels
Top Solution Authors