Alteryx Designer

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

Need help in picking the values between 2 and gets highlighted.

Highlighted
8 - Asteroid

Hi ,

Having 2 files, file 1 contains count and Actual and file 2 contains from and to and estimated 
expecting result as below which should pick based on the count from table 2, if actual is less than estimated it should be highlighted.

 

File 1
countActual
3813
3818
5414
5218
349
3017
43
2014
166
7724
10122
4818
11243
File 2
FromToEstimated
055
675
8108
111510
162512
263513
364515
465516
567017
718519
8610020
101more>23

 

Result

 

Result
countActualEstimated
381315
371815
541416
521816
34913
301713
435
201412
16612
772419
10122>23
481816
11243>23

 

 

Ex:count:54(line item 3 in file 1 ) actual is 14 and 54 is falling in file 2 from 46-55 and estimated for that is 16. so actual is less then estimated that is 16. so 14 should be higlited

Ex2:52(line item 4 in file 1 ) actual is 18 and 52 is falling in file 2 from 46-55 and estimated for that is 16. so actual is greated then estimated i.e 16. so 16 should not be higlited

 

Thanks for the help in advance 

Highlighted
12 - Quasar

There are a few options here. For example you can use the Generate Rows tool against the records in file 2 to create a row for each count and then process against that. Or you could use multi row logic to determine which row to check against.

Highlighted
13 - Pulsar

Attaching a sample workflow for your case.  Hope it helps. 

 

WorkflowWorkflowResultsResults

Highlighted
12 - Quasar

See attached for a starting point.

 

2018-06-14_12-05-59.png

Highlighted
ACE Emeritus
ACE Emeritus

Hi,

 

I used an Append tool to do the matching between File 1 and File 2.  Depending on how many records you have in the 2 input files, this may not be ideal, as the Append would drastically increase the record count for a step.  The Table tool also contains a Column Rule formula that will highlight in yellow the records where Actual is less than Estimated.

 

 

Capture1.PNGCapture2.PNG

Labels