SQLTeam.com | Weblogs | Forums

Mdx support required for a non profit organization


#1

100,000 records with 45 columns
Split to columns does not work because causes A,B,C,D,F,G varied in position, length and quantity
Dashes in records are only used for this explanation, they don't exist in the data base
The records in Excel come from a relieve stress center and the records look like:

SOURCE DATA:
Code (column 1)- - Causes of call (Column 20)
123 - -A,B,C,D
234 - -B,C,F,

I need to transform this records to produce:

STAGGING STAGE DESIRED:
Code (column 1)- - Causes of call (Column 20)
123 - - A
123 - - B
123 - - C
123 - - D
234 - - B
234 - - C
234 - - F

Challenge:
Part 1: Create a MDX or VBA program to transform the data to the STAGGING STAGE DESIRED.

If it is not possible to provide full code, please give me an idea about hoe to do this on: MDX or VBA

THANKS IN ADVANCE
JUAN CARLOS


#2

Juan Carlos,

Are the "A,B,C,D" and "B,C,F" within the same column?


#3

Yes the "A,B,C,D" and "B,C,F" are within the same column (Column 20) but in different rows, the total amount of rows is 100,000