Please help (Data Model)

Wed, 27 Aug 2014 10:54:34 GMT

Hi All,

Kindly find the below screen shot. Is this data structure is ok ? Please advice.

Below is the scrip i have used

MyTable:

Crosstable(Questions, Value,4)

SQL Select MYSTERY_SHOPPER, DEALER, COUNTRY, WAVE, Q1, Q2, Q3, Q4, Q5,Q6,Q7A,Q7B,Q8,Q9,Q10,Q11,Q12,Q13,

Q14,Q15A,Q15B,Q15C,Q15D,Q15F,Q15G,Q15H,Q15I,Q16,Q17,Q18,Q19,Q20,Q21,

Q22,Q23,Q24,Q25,Q26,Q27,Q28,Q29,Q30,Q31,Q32_A ,Q32_B,Q32_C,Q32_D,Q33,Q34,Q35,Q36,Q37,Q38,Q39,Q40,Q41,Q42,Q43,Q44,Q45,

Q46,Q47,Q48,Q49,Q50,Q51,Q52,Q53,Q54

From XX_JLR_SALES_DATA_ENTRY_NEW WHERE ENABLED='YES';

SALES:

Select MYSTERY_SHOPPER, DEALER, COUNTRY, WAVE,OVERALL_IMPRESSION_VALUE_CURRENT_WAVE,DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE,

WELCOME_COMMENTS, QUALIFY_COMMENTS, PRODUCT_PRESENTATION_COMMENTS, DEMONSTRATION_DRIVE_COMMENTS, NEGOTIATE_COMMENTS, KEEP_IN_CONTACT_COMMENTS,

OVERALL_SATISFACTION_COMMENTS, RECOMMENDATION_COMMENTS, TRADE_IN_EVALUATIONS, CURRENT_CAR,

DATE_VISIT, TIME_VISIT,INTEREST_MODEL,FIRST_GREETED_BY,SALES_EXECUTIVE_NAME,TEST_DRIVE_TAKEN ,TRADE_IN_CAR_EVALUATED, AREAS_IMPROVEMENT_COMMENTS

From XX_JLR_SALES_DATA_ENTRY_NEW WHERE ENABLED='YES';

CODE:

LOAD * Inline [

Description

Welcoming Customers,

Qualify,

Product Presentation,

Demonstration Drive,

Negotiate & Agree Sale,

Keep in Contact,

Overall,

Managing the External Environment,

Managing the Internal Environment,

Building Rapport,

Establishing Needs and Requirements,

Data management and follow up,

Selecting the Product,

Static Presentation,

Building Value,

Confirming the Choice,

Preparing for the Demonstration Drive,

Data Management,

Presenting the offer

];

topic Please help (Data Model) in QlikView