From Excel Datasource

  • 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