Comparing Data from from one table, Calling out Differences based on Timestamp !!

Siva1990

Hi, I am new in Alteryx and trying to figure out a workflow:

I have a single History table which gets updated daily with the timestamp. I have herewith attached the screenshot for reference. The left side table (History) contains all details and it has timestamp at the end. I need to compare the current timestamp with previous timestamp and bring the differences. The output i need is displayed on the right side of the image shown below.

I have attached an excel document for reference. Input(sheet) contains left side tables and output sheet contains the desired result.

Any help is appreciated.

Thank you!

Alteryx Workflow-Upload.xlsx

Workflow

Date Time

Accepted answers

Luke_C

Hi @Siva1990

Here's a way to compare all the fields. In the future please attach your data rather than a screenshot.

New Workflow2.yxmd

All comments

FrederikE

Multi-Row Tool with such a config after sorting the records by Projects:

IF [Name]=[Row+1:Name]
THEN [Row+1:Price]
ELSE Null()
ENDIF

See the attached WF

New Workflow2.yxmd

Luke_C

Hi @Siva1990

Here's a way to compare all the fields. In the future please attach your data rather than a screenshot.

New Workflow2.yxmd

Siva1990

Thanks for the workflow model. How did you get Name2 ? I have attached the screenshot for reference.

I have attached my excel document for designing model.

Many Thanks,

Siva

Siva1990

I have attached my excel file. Is it possible to develop the model from that ?

Thanks

Luke_C

Hi @Siva1990

The transpose tool automatically adds fields called Name and Value. Since your data has a field called Name, the transpose tool goes to Name2 since we can't have 2 fields with the same name in alteryx.

I'd strongly suggest you try on your own to adapt my solution to your excel file so you learn Alteryx more rather than have the work done for you. If you experience specific issues you can definitely come back and post the workflow and I'd be more than happy to look into it.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703