Challenge #260: Fuel Me Once...

[glenperes]

Solution:

Spoiler

[JP_SDAK]

Great way to start a Monday morning 🙂

Spoiler

[abrouwer]

Solution attached

[TonyA]

Here's my solution

Spoiler

Added a test to make sure a card isn't associated with multiple vans, which would break the workflow (and would require that the transaction file included the van number).

[pcan415]

Spoiler

[Maskell_Rascal]

Hey @mpennington 

I like the direction you took, but I'd double check that Generate Rows tool in your workflow. You have it configured to a Byte, but would want it to be at least an Int32 data type, otherwise you're not generating all the rows. 

If using the RegEx formulas in the tool, you simplify the regex code like this:

Spoiler

Best Regards,

Phil

[mpennington]

@Maskell_Rascal 

Good catch, kind sir! I'm guessing I was able to match the results because none of flagged cases were above 255.  Thanks for the insight, I really appreciate it. I've been using the Bytes a bit too aggressively, trying to make my workflows smaller.  I will  need to watch out for that. 😁

Best Regards,

Michael

[mike_w]

no more cheating on gas transactions!  😎

Spoiler

[Toons]

My solution :

Spoiler

[Jon_Taylor]

Spoiler

 Alteryx file blocked by employer for upload