Data Action issue

[sumeet1987]

Hello,

I need data action to copy data from input template to SAC story (Planning model.). Only challenge I am facing how to map start date and end date and populate amounts to Periods . Please see below example.

Date granuality is YYYYMM. 

Input template:

Account	Cost Center	SPeriod	Tperiod	Amount
61061000	10101301	202507	202509	1000
61061000	17101301	202510	202512	2000
61020000	10101301	202508	202510	5000
61020000	17101301	202507	202509	6000

Target:

Account	Cost Center	P1	P2	P3	P4	P5	P6	P7	P8	P9	P10	P11	P12
61061000	10101301							1000	1000	1000
61061000	17101301										2000	2000	2000
61020000	10101301								5000	5000	5000
61020000	17101301							6000	6000	6000

[ThomasK]

Hi @sumeet1987 , is the "input template" data in an XLS to upload or is it already imported data which is in the same data model but in a different version?

[sumeet1987]

Hello Thomas,

Input template is on model1 and target split to periods is on model2 i.e. different models for source and target. 

Version is same only .