Pivot Operation needs "case sensitive" option

pgarces · August 18, 2011 3:12PM

Pivot Operation in DataManager is de-duplicating record when record is not a duplicate

Hi,

I am having an issue in DataManager, where I am using the De-pivot operation to make some changes to the dataset. Once done with the changes, I connect it to the Pivot operation and now have less records than before. No records were removed and technically there are no duplicate records. After further investigating, I found that the Pivot operation is de-duplicating a record that it shouldn't. The records are similar, but since the first character is capitalized in one record and the other is not, (ex. "Paul" & "paul"), technically they are not duplicates.

Any suggestions on how to work around this or if this is a know issue?

Thanks,

Paul

steve · August 19, 2011 1:18AM

Everything in Omniscope is case insensitive (so Paul and paul are considered the same value) but case preserving (so paul and Paul are preserved in record details), except in places where you have an option for this (such as Join/Merge).

I have reclassified this as an idea.

pgarces · August 22, 2011 10:53AM

Thanks Steve. As a work around, I ended up modifying the record in question by adding an additional character,(Paul11), made the changes to the dataset, then removed the additional character. This allowed me to preserve the dataset.

Welcome!

Categories

Ideas Parade