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

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
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
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
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 |
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 |
Thanks
Garf