Challenge #260: Fuel Me Once...

A solution to last week's challenge can be found here. Source: https://www.requestyourcar.com/blog/details/what-is-corporate-fleet-vehicle/

Many businesses require a fleet of vehicles to conduct their business. Eventually, all of those vehicles need to be refueled so many of these companies choose to issue credit cards that are assigned to a particular vehicle in the fleet. While this is convenient, it can result in unscrupulous behavior...

For this week's challenge, use the provided datasets to create a workflow that flags potentially illegitimate transactions for review.

challenge_260_start_file.yxmd

challenge_260_solution.yxmd

Parse

Join

Preparation

Data Analysis

Intermediate

Core

Transform

Accepted answers

All comments

Aaron_Harter

All fueled up for the week!

Spoiler

challenge_260_AB Data_Aaron.yxmd

Blake

Gassed up and ready to go for the week.

Spoiler

challenge_260_start_file_BH.yxmd

Luke_C

Spoiler

challenge_260_solved_lc.yxmd

Kenda

Spoiler

Love a good Alteryx math problem!

challenge_260_start_file.yxmd

DeanWest

⛽

Spoiler

challenge_260_solution_DeanWest.yxmd

Spalders

Spoiler

It's a gas!

challenge_260_ADS.yxmd

patrick_digan

Spoiler

challenge_260_start_file.yxmd

ulaimins

Spoiler

challenge_260_start_file_ulaimins.yxmd

Tony_Castillo

Spoiler

philipmannering

The "Regular" being called "Gas" and not "Petrol" fooled me twice.

Spoiler

Workflow

Challenge 260 - Fuel Me Once.yxmd

RolandSchubert

Spoiler

challenge_260_solution_rsc.yxmd

balajilolla

Spoiler

Solution Attached

challenge_260_start_file.yxmd

twilko2

Spoiler

challenge_260_solution.yxmd

jferrone

Happy Monday and thank you for the weekly challenge

Spoiler

challenge_260_solution_jf.yxmd

phottovy

Spoiler

challenge_260_ph_solution.yxmd

JITHINPR

My Solution

challenge_260_start_file.yxmd

Maskell_Rascal

Fun challenge to start the week! Here is my solution:

Spoiler

challenge_260_Phil_Nelson.yxmd

OllieClarke

Here's my solution:

Spoiler

Reminded myself of string calcs rather than regexing 🙂

challenge_260_OC_Solution.yxmd

mpennington

Got it. Attached.

Spoiler

)" />RegEx in a Generate Row Tool

)

challenge_260_MP.yxmd

glenperes

Solution:

Spoiler

260.bmp

GP_challenge_260_start_file.yxmd

JP_SDAK

Great way to start a Monday morning 🙂

Spoiler

challenge_260_start_file.yxmd

abrouwer

Solution attached

challenge_260_solution_file - AJB.yxmd

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).

challenge_260_TonyA.yxmd

pcan415

Spoiler

challenge_260_Fuel_Me-Once.yxmd

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

mike_w

no more cheating on gas transactions! 😎

Spoiler

challenge_260_mrm.yxmd

Toons

My solution :

Spoiler

challenge_260_Solution_Toons.yxmd

Jon_Taylor

Spoiler

Alteryx file blocked by employer for upload

LHolmes

Maybe they needed candybars? Nice beginning challenge.

Spoiler

challenge_260_solution_lmh.yxmd

apathetichell

Another problem electric vehicle fleets could solve...

260 solution.yxmd

RichoBsJ

Hi! Here my solution 🙂

Spoiler

challenge_260_richobsj.yxmd

Qiu

I guess the answers will end up pretty much the same. 😁

Spoiler

challenge_260-Qiu.yxmd

BYoung

@Blake I like your method to hard code the fuel type in with a formula, I did the same thing...no indication the vehicle numbers would change from vehicle to vehicle.