I have a feed in CSV format. The records has been duplicated in the feed with some unique combination.
Ex:
Record 1: E1 E2 E3 E4 125
Record 2: E1 E2 E3 E4 126
Record 3: E1 E2 E3 E4 127
Here only the value has been changed but all other combinations are same.
I want to update the cube value with the latest one. i.e with 127.
Any Logic? Thanks in advance.
KKMK.
Update the latest record from the CSV File
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Update the latest record from the CSV File
If they are ordered like this in the source file then there is no issue, your result will be 127 in the cube, provided you don't accumulate values, but use simple CellPutN instead.
Kamil Arendt