Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

To Limit the Digits inside Column

selinunlu
7 - Meteor

hello everyone,

 

I want to limit digits in columns. Firm name can be max 72 digit and tax number should 10 or 11 but there are many numbers with 9 digits.So which formula should be used for this?

 

 

selinunlu_0-1647451178646.png

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @selinunlu 

 

If you want to only check you can do like below.

 

atcodedog05_0-1647451996943.png

 

 

Hope this helps : )


Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

selinunlu
7 - Meteor

Thanks for help.

 

I couldn't get this. I want to see whole text in the  firm name check column. For example, if firm name AAAAAAAAAAB less than 72 digit I want to see all inside the cell but if it is higher than 72, I want to see the name till seventy-second digit.

Sincerely.

Labels
Top Solution Authors