Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 03, 2017 at 06:34 PM

    Hello Krishna - Design Studio isn't an ETL tool; what is the business reason for wanting to do this?

    Add comment
    10|10000 characters needed characters exceeded