Dynamic Formula

[Suppess]

Hello, 

I'm trying to create a formula to bucket values appropriately between Table 1 and Table 2. In this example we use 'Rate' in Table 1 to find 'Bucket'. The Table 2 has lookup values for 'Bucket'. Please let me know if any solutions are available in Alteryx?

[Clifford_Coon · Accepted solution]

Hi @Suppess ,  Here is one option:

Take the data vertical, combine, sort, multi-row.

Happy Solving.

 

[geraldo]

@Suppess 

Here's a very similar example @Clifford_Coon 
I made an example to meet your need, I don't know of any tool that does this.

in Attachment the Workflow

[Yoshiro_Fujimori]

Hi @Suppess ,

Here is one way of doing this.

There might be better solution, but I could not figure out the way with "Dynamic Formula" as stated in your title.

Workflow

I hope this helps.

[flying008]

Hi, @Suppess 

There is a other way , don't need more formula for get your want.