Skip to Content
0
Former Member
May 03, 2017 at 04:35 PM

Possible to convert a table in Design Studio in the following way without changing data source?

42 Views Last edit May 03, 2017 at 04:37 PM 2 rev

Hi all,

Is there a way, in Design Studio 1.6 SP04, to convert a table with a text column followed by multiple date columns into a table with a text column followed by a single text column with all the headers for the date columns followed by a single date column that contains all the dates from the old table without changing anything in the Universe that I'm bringing the original data from? Examples below.

Before conversion:

Name| Date A| Date B| Date C

X| 1/1/2014| 4/2/2015| 6/9/2015

...

After conversion:

Name| Date type| Date

X| A| 1/1/2014

X| B| 4/2/2015

X| C| 6/9/2015

...

Thanks,

Krishna Pai