Update the latest record from the CSV File

Post Reply
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Update the latest record from the CSV File

Post by kkmk »

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.
User avatar
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

Post by qml »

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
Post Reply