Skip to Content
0
Former Member
Feb 22, 2011 at 03:21 PM

Any ideas on how to swap a to&from date table to monthly using DI?

28 Views

New to DI, so after a bit of product usage advice!

I've got a table that looks like this...

ID,NAME,SDATE,EDATE,TOTALDAYS,WEEKDAYS

1,James,01/01/2010,10/01/2010,10,6

2,John,03/02/2010,19/02/2010,16,13

1,James,15/04/2010,23/07/2010,100,72

3,Chris,05/08/2010,05/08/2010,1,1

2,John,30/08/2010,03/09/2010,5,5

3,Chris,28/09/2010,06/10/2010,9,7

I want it in a format thats a bit more like this...

YEAR,MONTH,ID,NAME,TOTALDAYS,WEEKDAYS

2010,JAN,1,James,10,6

2010,FEB,2,John,16,13

2010,APR,1,James,16,12

2010,MAY,1,James,31,21

2010,JUN,1,James,30,22

2010,JUL,1,James,23,17

2010,AUG,3,Chris,1,1

2010,AUG,2,John,2,2

2010,SEP,2,John,3,3

2010,SEP,3,Chris,3,3

2010,OCT,3,Chris,6,4

Anyway to do this type of operation in DI?

It's not a huge data set (k's of rows) - but I need it in this sort of format do do some monthly reporting. So far in DI I've only really used simple lookups and joins - more a load tool - so hope this type of thing is relativley standard stuff?

Thanks for any advice!

j.