Query with data

[#1]

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

Age Buckets	26-34
Age Buckets	35-44
Age Buckets	45-54
Age Buckets	Grater Than 55
Age Buckets	Less Than 25

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

[#2 · Accepted solution]

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

[#3]

Its really a magic,

Thanks !!