Skip to Content
0

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

May 03, 2017 at 04:35 PM

28

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
May 03, 2017 at 06:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded