Hello All,

       I have a requirement to pull data from the excel sheet (which is not a straight forward task since the format of the data is different) and load in to the SQL table. Following is the format of the source file and I have mentioned the output format as well. So need your assistance to complete this.

Sample Excel Sheet

Notes:

Ignore the summary rows and the following rows to process

If a Row contains Q1 or Q2 or Q3 or Q4 then the following records needs to be processed.First by ignoring the immediate next two rows.

Only need to take the columns which has "()" as a part of it

The value NA has to be treated as "0"

The output is mentioned in the separate sheet.

Thanking you in advance.

Can you take the data as a whole and load it into a table?

You then would be able to execute however queries against it you wish and achieve your goal.

Hi,

You can take directy into the temporary table and process the needs using conditional split and derived column or data conversions.

Not sure how effective it would be as we have multiple excel sheets of this type to process from a folder. Anyways thanks a lot for your response will try checking this.