Price Variation

[Scheruku]

Hi All,

I have a product and store ID level file for which we are trying to identify the change in price in same month for same product and store id:

We are trying to identify the latest variance in cost price in same month for same product and store ID..

Attached the raw file

Raw File -

GRN Number	GRN Generated Date	Product ID	StoreID	PO Number	PO Type	Cost Price
123456	26-09-2017 00:00	AB-F0002	123	2602688		110.122656
1234567	01-09-2017 17:12	AB-F0002	123	2601736		107.984352
189045	20-09-2017 17:11	AB-F0002	123	2789345		94
286541	01-10-2017 17:11	AS-F0002	146	2601734		75
286856	10-10-2017 17:11	AS-F0002	146	2789344		200
286856	15-10-2017 17:11	AS-F0002	146	2789344		91
286856	20-10-2017 17:11	AS-F0002	146	2789344		200
286856	12-12-2017 16:11	FM-F0002	146	2789340		500

Latest	OldPrice
GRN Number	GRN Generated Date	Product ID	StoreID	PO Number	PO Type	Cost Price	GRN Number	GRN Generated Date	Product ID	StoreID	PO Number	PO Type	Cost Price
123456	26-09-2017 00:00	AB-F0002	123	2602688		110.122656	189045	20-09-2017 17:11	AB-F0002	123	2789345		94
286856	20-10-2017 17:11	AS-F0002	146	2789344		200	286856	15-10-2017 17:11	AS-F0002	146	2789344		91

[danrh · Accepted solution]

Try something like this:

The Multi-Row Formula tool adds an incremental counter when the price changes.  The Unique tool then grabs the first of each of those increments --- the first 1 will be the latest price, and the first 2 will be the latest price where the price was different.  The Filters then grab the 1's and the 2's and Join them so you end up with a side-by-side comparison.

Hopefully this gets you closer.  Reach out if you need some more help!

[ponraj · Accepted solution]

Attaching a sample workflow for your case. Hope this is helpful.

WorkflowResults

[Scheruku · Accepted solution]

Thank you very much for your help.

[Scheruku]

I have used this approach. Thank you very much.