Results 1 to 4 of 4

Thread: To organize the excel file and also get the ranges of values from database

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    To organize the excel file and also get the ranges of values from database

    My input is Excel file --

    CPT ICDCOVERED
    87088 003.1 -- some cells have only single values
    038.0,038.10-038.11,038.19,038.2,038.3,038.40-038.44,038.49,038.8,038.9 -- some cells have both comma ',' seperated as well as ranges ' - '
    276.2, 278.1 -- some values are comma seperated
    276.4 - 276.9 --some values are ranges separeted by ' - ' ranges
    286.6
    88037 034.02, 103.04 -- when there is comma beween the values it should load the values in seperate cells.
    023.01, 123.03
    201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell with its corresponding values of CPT (fisrt column)

    Excepted Output Excel file---

    CPT ICDCOVERED
    87088 003.1
    87088 038.0
    87088 38.10-038.110 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
    87088 038.19
    87088 038.2
    87088 038.3
    87088 038.40-038.44 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
    87088 038.49
    87088 038.8
    87088 038.9
    87088 276.2
    87088 278.1
    87088 276.4
    87088 286.6
    88037 034.02
    88037 103.04
    88037 023.01
    88037 123.03
    88037 201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell

    I need to organize the Excel before I am using a ELT tool to load the values from Excel to SQL SERVER, but first I need to organize the Excel values so that it can be loaded properly.

    I am also attaching the Excel sample file.

    Thanks , I would really appreciate your help.
    Ali
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •