Storing Data in Alteryx

[adarsh2608]

Hello 

Data (A) contains data from the workflow and data (B) is data of (A) from the previous run. everytime when workflow is ran data (A) is stored and that sorted data is used in data(B) in next run. I need help in building the method this

year	item A	position A	Value A	position A	item B	position B	Value B	position B
Jan-2022	10	A	50	R	20	A	10	A
Feb-2022	20	A	50	R	30	G	20	A
mar-2022	20	A	30	G	10	A	10	A
Apr-2022	30	G	10	A	10	A	10	A

From the above we have 2 section A and B . Basically data A is taken as per the workflow and data B is  values of data A from the previous run.So every time when i run the workflow Data A is need to store and previously stored values of data A should assign to Data B

[BrandonB]

What about transforming the data so that it is put into a vertical format? 

[adarsh2608]

Hello @BrandonB 

I need to store the data temporary in alteryx . every time when  i run the workflow i will new data(as per workflow) plus previous run data( temporary stored data)

[BrandonB]

Do you need the latest month update for each Item? You can do that with a Sample tool and could of course output to a YXDB each time. 

[adarsh2608]

Hello @BrandonB 

Data	item A	position A	Value A	position A	item B	position B	Value B	position B
Jan-2022	10	A	50	R	20	A	10	A
Feb-2022	20	A	50	R	30	G	20	A
mar-2022	20	A	30	G	10	A	10	A
Apr-2022	30	G	10	A	10	A	10	A

From the above we have 2 section A and B . Basically data A is taken as per the workflow and data B is  values of data A from the previous run.So every time when i run the workflow Data A is need to store and previously stored values of data A should assign to Data B