Hi all,

Does anyone know how to unpivot all properties but specified ones?

It's suppose to take regular expressions, but I can't figure out how to write it.

(^(?!Compound_ID).*\$) works to exclude the property named "Compound_ID", but what if I'd like to be more fuzzy in property name to be excluded from pivot (Compound_ID, Compound_Name, Date) ?

Thanks in advance,

Pierre