Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

From Excel Datasource Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 9:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668
Hi geniuses,

I have to create a report from an excel datasource which have 2 columns:

Econ	                          Designation
D.01.01.01 Search APCV
D.01.01.02 Search AAPCV
D.01.01.03 Search AQSD
D.01.01.03.00 Search TOR
D.01.01.03.00.09 Search FGO
D.01.01.03.01 Search KJH
D.01.01.03.02 Search KIL
D.01.01.03.03 Search FRT
D.01.01.03.04 Search TRE
D.01.01.03.05 Search TRACK
D.01.01.03.A0.00 Search SOM

Where i need a column (LEVEL) to structure this info in levels:
D.01.01.03 is Level 1
D.01.01.03.00 is Level 2 of value above (drilldown structure)
D.01.01.03.00.09 Level 3 of value above

We can find here 5 levels.

Another column (VALUE) with the last 2 numbers after the last dot '.' of econ.

Thanks guys, hope this exposition is clear to you
Post #1434331
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse