🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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

User: "garlefzumfelde"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with