http://forums.visokio.com/discussions/tagged/de-pivot/feed.rss Mon, 30 Oct 17 15:21:39 -0400 Tagged with de-pivot - Visokio Forums en-CA http://forums.visokio.com/discussion/968/idea-variable-column-names-and-de-pivoting Fri, 02 Sep 2011 13:59:16 -0400 ygulla 968@/discussions
Input data is stored in a csv file, it has a daily changing number of columns (say 20-25), 10 of which have fixed names while the rest are named with dates. I want to de-pivot only the date-named columns.

The problem is that the number and names of the date columns change daily. Hence a simple de-pivot operation doesn't work once the data has been changed. Ideally I want a de-pivot option where it de-pivots all the columns apart from the selected ones.

Is it possible to achieve such de-pivoting in Omniscope some way? And if not would an option 'de-pivot everything apart from selected columns' be possible to include into de-pivot operation?

P.S. I tried every combination of operations I thought might lead me somewhere, and almost got the result, but in Summarise operation selecting "All fields" doesn't keep all the fields selected after the field names changed, the way that most other operations work. Is that intended?]]>