Page 1 of 1

Update the latest record from the CSV File

Posted: Thu Feb 02, 2012 3:48 pm
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.

Re: Update the latest record from the CSV File

Posted: Thu Feb 02, 2012 5:25 pm
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.