Adjust Date with Attribute Value in Time Series Data [SOLVED]

GzF

Hi,

I have got some Time Series Data. The Data I have are summed up for every month. In addition a got the production date (MM.YYYY) of each device at the end of the data. The Time Series Index Attribute is calles Time.

It looks like

ID	Time	Data-Value	Production-Date
1	1	XXX	01.2014
1	2	XXX	01.2014
1	3	XXX	01.2014
2	1	XXX	03.2014
2	2	XXX	03.2014
2	3	XXX	03.2014

Now, I would like to add a new attribute Correponding Month adding up the Production-Date and the Value from the Time attribute resulting in

ID	Time	Data-Value	Production-Date	Corresponding Month
1	1	XXX	01.2014	02.2014
1	2	XXX	01.2014	03.2014
1	3	XXX	01.2014	04.2014
2	1	XXX	03.2014	04.2014
2	2	XXX	03.2014	05.2014
2	3	XXX	03.2014	06.2014

I know how to use Adjust Date and add an integer to the Month Value. But how can I extract the integer from the Time Value
Thanks
Garf

MariusHelf

Hi Garf

the date_add() function of Generate Attribute is your friend. Have a look at the process below for an example of application.

Best!
~Marius

<宏/ >

GzF

Hi Marius,

that solves the Problem in a really nice way.
Thanks a lot.
Garf