PQ storing data from previous query not file and comparing variation

[daleholden]

HI Guys

PQ head scratcher for March 2022 ?

Setup

I get a file from online retailer several times daily to show live items for sale.

This has the unique item number for listing but it also has a supplier SKU.

I bring this back into PQ and use 2 parameters to look at sku then go off to get price from suppliers api.

At this point i now know price of supplier and stock and can compare with my online retailer.

I can then adjust qty either remove from sale or put back for sale all depending on supplier info.



This i have working but i want to work out how i can store the price from the supplier each time so i can compare when the next file comes in.

Eg

13 Mar 2022

SKU 1234 Supplier Cost £100 Diff £0 Online Price £120

14 Mar 2022

SKU 1234 Supplier Cost £120 Diff £20 Online Price £140

15 Mar 2022

SKU 1234 Supplier Cost £110 Diff -£10 Online Price £130



Hope this makes sense it needs to look back a previous files price and adjust Online price accordingly

The issue with this is the file i download does not have the data i need it is only until the query has run and then it can compare. Struggling to work out how to do this and keep the supplier data stored.