March 22, 2013 at 9:25 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply