Query with data

Wed, 02 Apr 2014 09:44:16 GMT

Hello All,

I want to flatten the data.

I have 3 fields :survey_id,Option, CategoryOptions

the survey keeps increasing and accordingly the Options and the CategoryOptions as per the requirements.

I want to flatten this data.

ie.i want to have different fields for different options.and that field will be have category option as its value.

At present the data is like below

Option CategoryOption

i want in the below matter

Age Buckets

26-34

35-44

45-54

Grater Than 55

Less Than 25

Cant use wildmatch.

please find the attached demo data.

Please help me with this problem

Thanks and Regards,

Priya

Re: Query with data

Wed, 02 Apr 2014 10:04:15 GMT

Add the keyword GENERIC infront of Load and see the magic,

GENERIC LOAD survey_id,

[Option Category],

Options

FROM

[<Path>\Flatten Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Thanks,

Prabhu

Wed, 02 Apr 2014 10:08:36 GMT

Its really a magic,

Thanks !!