Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

Getting Load error

Hi Team,

     I am getting the error even if file is loaded properly.

Regards,

KK

KK
1 Solution

Accepted Solutions
sunny_talwar

Try this:

Directory;

LOAD Start,

    Duration,

    Operator,

    [Real Time Session ID],

    skill,

    phoneNumber,

    email,

    identifier,

    [chat_customer_satisfaction_1(ES)],

    [chat_customer_satisfaction_2(ES)],

    [chat_customer_satisfaction_3(ES)],

    [chat_customer_satisfaction_4(ES)],

    [chat_first_contact_resolution(ES)],

    [send_transcript(ES)],

    [ESQ_s1 q2],

    [ESQ_s1 q3],

    [ESQ_s1 q4],

    [ESQ_s1 q5],

    [ESQ_s1 q6],

    [ESQ_s1 q7],

    [ESQ_s1 q10],

    [ESQ_s1 q11],

    [ESQ_s1 q12],

    [ESQ_s1 q13],

    [ESQ_s1 q14],

    [ESQ_s1 q15],

    [ESQ_s1 q16],

    [ESQ_s2 q9],

    [ESQ_s2 q10],

    [ESQ_s2 q11],

    [ESQ_s2 q12],

    [ESQ_s2 q13],

    [ESQ_s2 q14],

    [ESQ_s2 q15],

    [ESQ_s2 q16],

    [ESQ_s2 q17],

    [ESQ_s2 q18],

    [ESQ_s2 q19],

    [ESQ_s3 q9],

    [ESQ_s3 q10],

    [ESQ_s3 q11],

    [ESQ_s3 q12],

    [ESQ_s3 q13],

    [ESQ_s3 q14],

    [ESQ_s3 q15],

    [ESQ_s3 q16],

    [ESQ_s3 q17],

    [ESQ_s3 q18],

    [ESQ_s4 q2],

    [ESQ_s4 q3],

    [ESQ_s4 q4],

    [ESQ_s4 q5],

    [ESQ_s4 q6],

    [ESQ_s4 q9],

    [ESQ_s4 q10],

    [ESQ_s4 q11],

    [ESQ_s4 q12],

    [ESQ_s4 q13],

    [ESQ_s4 q14],

    [ESQ_s4 q15],

    [ESQ_s5 q9],

    [ESQ_s5 q10],

    [ESQ_s5 q11],

    [ESQ_s5 q12],

    [ESQ_s5 q13],

    [ESQ_s5 q14],

    [lead_value(OS)],

    [operator_first_contact_resolution(OS)],

    [order_value(OS)],

    [qualified_chat(OS)],

    [OSQ_s1 q6],

    [OSQ_s1 q7],

    [OSQ_s1 q8],

    [OSQ_s1 q9],

    [OSQ_s1 q10],

    [OSQ_s1 q11],

    [Type of Chat* (Checkbox)],

    [Pre-Sales Category (Checkbox)],

    [Please Specify (which competitor pre-sales) (Text Field)],

    [Please Specify (other pre-sales) (Text Field)],

    [Ready to Buy Category (Checkbox)],

    [Please Specify (Other Ready to Buy) (Text Field)],

    [Post-Sales & Non-related Category (Checkbox)],

    [Please Specify (post-sales & non related) (Text Field)],

    [Main product of interest for the customer (Dropdown Box)],

    [Version of product (Dropdown Box)],

    [Second Product Of Interest for the customer (if applicable) (Dropdown Box)],

    [Third product of interest for the customer (if applicable) (Dropdown Box)],

    [Product recommended to the customer (Dropdown Box)],

    [Additional Offer (Checkbox)],

    [Chat Agent Action (Checkbox)],

    [Please Specify (other Department) (Text Field)],

    [How was the referral made? (Checkbox)],

    [Please specify (other action) (Text Field)],

    [Status of customer request (Dropdown Box)],

    [Comments (Text Field)],

    [Salesforce Case Number (Front Desk Only - when transferred) (Text Field)],

    [OSQ_s3 q6],

    [OSQ_s3 q7],

    [OSQ_s3 q8],

    [OSQ_s3 q9],

    [OSQ_s3 q10],

    [OSQ_s3 q11],

    [OSQ_s3 q12],

    [OSQ_s3 q13],

    [OSQ_s3 q14],

    [OSQ_s3 q15],

    [OSQ_s3 q16],

    [OSQ_s3 q17],

    [OSQ_s3 q18],

    [OSQ_s3 q19],

    [OSQ_s3 q20],

    [OSQ_s3 q21],

    [OSQ_s3 q22],

    [OSQ_s3 q23],

    [OSQ_s3 q24],

    [OSQ_s3 q25],

    [OSQ_s3 q26],

    [OSQ_s3 q27],

    [OSQ_s4 q1],

    [OSQ_s4 q2],

    [OSQ_s4 q7],

    [OSQ_s4 q8],

    [OSQ_s4 q9],

    [OSQ_s4 q10],

    [OSQ_s4 q11],

    [OSQ_s5 q5],

    [OSQ_s6 q6],

    [message(OF)],

    [subject(OF)],

    LP_Visitor_Category,

    [chat-button-name],

    [chat-button-room],

    pagecounter,

    InteractiveChat,

    DisconnectedBy,

    Proxy_IP,

    visitorActive,

    pageLoadTime,

    unit,

    PageName,

    language,

    campaign_medium,

    room,

    page_room,

    SectionS,

    [impression-query-room],

    [impression-query-name],

    [click-query-channel],

    [click-query-name],

    [click-query-state],

    [click-query-room],

    OrderTotal,

    CartTotal,

    Exclude,

    ErrorCounter,

    maxCartTotal,

    campaign_source,

    ExcludeEstore,

    [Pre-Hot-Lead],

    [Hot-Lead],

    SalesCounter,

    ErrorCtr,

    campaign_search_keywords,

    SaleAfterChat2.0,

    SaleAfterChat1.0,

    SaleAfterChat3.0,

    SaleAfterChat4.0,

    OrderNumber,

    OrderNumberForRules,

    OrderNumberForReports,

    OrderTotalForReports,

    DuplicateOrderNumberCounter,

    TrialPage,

    ConversionStage,

    ChatEngage,

    Section,

    product3,

    product2,

    product1,

    live_engage_control_group,

    deliveryHook_BrowsingSite,

    [engageFlagOncartpage-comingfromaffiliates(2013links)-ACADLT,InventorLT,InventorLTSuite_EnterPage],

    [engageFlagCoreUSeStorevisitors[fromUSandCA]]]_EnterSite],

    Currency,

    excludeEstoreEmea,

    ChatRule,

    ReportedChatStart,

    ReportedChatEnd,

    Browser,

    [Host IP],

    [Operating System],

    Country,

    City,

    Organization,

    [World Region],

    [Postal Code],

    [Time Zone],

    ISP,

    [Connection Type],

    [Pre-Chat Survey],

    [Exit Survey],

    [Operator Survey],

    [Offline Survey]

FROM

Demo_Chat.xlsx

(ooxml, embedded labels, table is Sheet1);

For more details on the idea of excape sequence, check here: Escape sequences

View solution in original post

3 Replies
Anonymous
Not applicable

Check this?

sunny_talwar

Try this:

Directory;

LOAD Start,

    Duration,

    Operator,

    [Real Time Session ID],

    skill,

    phoneNumber,

    email,

    identifier,

    [chat_customer_satisfaction_1(ES)],

    [chat_customer_satisfaction_2(ES)],

    [chat_customer_satisfaction_3(ES)],

    [chat_customer_satisfaction_4(ES)],

    [chat_first_contact_resolution(ES)],

    [send_transcript(ES)],

    [ESQ_s1 q2],

    [ESQ_s1 q3],

    [ESQ_s1 q4],

    [ESQ_s1 q5],

    [ESQ_s1 q6],

    [ESQ_s1 q7],

    [ESQ_s1 q10],

    [ESQ_s1 q11],

    [ESQ_s1 q12],

    [ESQ_s1 q13],

    [ESQ_s1 q14],

    [ESQ_s1 q15],

    [ESQ_s1 q16],

    [ESQ_s2 q9],

    [ESQ_s2 q10],

    [ESQ_s2 q11],

    [ESQ_s2 q12],

    [ESQ_s2 q13],

    [ESQ_s2 q14],

    [ESQ_s2 q15],

    [ESQ_s2 q16],

    [ESQ_s2 q17],

    [ESQ_s2 q18],

    [ESQ_s2 q19],

    [ESQ_s3 q9],

    [ESQ_s3 q10],

    [ESQ_s3 q11],

    [ESQ_s3 q12],

    [ESQ_s3 q13],

    [ESQ_s3 q14],

    [ESQ_s3 q15],

    [ESQ_s3 q16],

    [ESQ_s3 q17],

    [ESQ_s3 q18],

    [ESQ_s4 q2],

    [ESQ_s4 q3],

    [ESQ_s4 q4],

    [ESQ_s4 q5],

    [ESQ_s4 q6],

    [ESQ_s4 q9],

    [ESQ_s4 q10],

    [ESQ_s4 q11],

    [ESQ_s4 q12],

    [ESQ_s4 q13],

    [ESQ_s4 q14],

    [ESQ_s4 q15],

    [ESQ_s5 q9],

    [ESQ_s5 q10],

    [ESQ_s5 q11],

    [ESQ_s5 q12],

    [ESQ_s5 q13],

    [ESQ_s5 q14],

    [lead_value(OS)],

    [operator_first_contact_resolution(OS)],

    [order_value(OS)],

    [qualified_chat(OS)],

    [OSQ_s1 q6],

    [OSQ_s1 q7],

    [OSQ_s1 q8],

    [OSQ_s1 q9],

    [OSQ_s1 q10],

    [OSQ_s1 q11],

    [Type of Chat* (Checkbox)],

    [Pre-Sales Category (Checkbox)],

    [Please Specify (which competitor pre-sales) (Text Field)],

    [Please Specify (other pre-sales) (Text Field)],

    [Ready to Buy Category (Checkbox)],

    [Please Specify (Other Ready to Buy) (Text Field)],

    [Post-Sales & Non-related Category (Checkbox)],

    [Please Specify (post-sales & non related) (Text Field)],

    [Main product of interest for the customer (Dropdown Box)],

    [Version of product (Dropdown Box)],

    [Second Product Of Interest for the customer (if applicable) (Dropdown Box)],

    [Third product of interest for the customer (if applicable) (Dropdown Box)],

    [Product recommended to the customer (Dropdown Box)],

    [Additional Offer (Checkbox)],

    [Chat Agent Action (Checkbox)],

    [Please Specify (other Department) (Text Field)],

    [How was the referral made? (Checkbox)],

    [Please specify (other action) (Text Field)],

    [Status of customer request (Dropdown Box)],

    [Comments (Text Field)],

    [Salesforce Case Number (Front Desk Only - when transferred) (Text Field)],

    [OSQ_s3 q6],

    [OSQ_s3 q7],

    [OSQ_s3 q8],

    [OSQ_s3 q9],

    [OSQ_s3 q10],

    [OSQ_s3 q11],

    [OSQ_s3 q12],

    [OSQ_s3 q13],

    [OSQ_s3 q14],

    [OSQ_s3 q15],

    [OSQ_s3 q16],

    [OSQ_s3 q17],

    [OSQ_s3 q18],

    [OSQ_s3 q19],

    [OSQ_s3 q20],

    [OSQ_s3 q21],

    [OSQ_s3 q22],

    [OSQ_s3 q23],

    [OSQ_s3 q24],

    [OSQ_s3 q25],

    [OSQ_s3 q26],

    [OSQ_s3 q27],

    [OSQ_s4 q1],

    [OSQ_s4 q2],

    [OSQ_s4 q7],

    [OSQ_s4 q8],

    [OSQ_s4 q9],

    [OSQ_s4 q10],

    [OSQ_s4 q11],

    [OSQ_s5 q5],

    [OSQ_s6 q6],

    [message(OF)],

    [subject(OF)],

    LP_Visitor_Category,

    [chat-button-name],

    [chat-button-room],

    pagecounter,

    InteractiveChat,

    DisconnectedBy,

    Proxy_IP,

    visitorActive,

    pageLoadTime,

    unit,

    PageName,

    language,

    campaign_medium,

    room,

    page_room,

    SectionS,

    [impression-query-room],

    [impression-query-name],

    [click-query-channel],

    [click-query-name],

    [click-query-state],

    [click-query-room],

    OrderTotal,

    CartTotal,

    Exclude,

    ErrorCounter,

    maxCartTotal,

    campaign_source,

    ExcludeEstore,

    [Pre-Hot-Lead],

    [Hot-Lead],

    SalesCounter,

    ErrorCtr,

    campaign_search_keywords,

    SaleAfterChat2.0,

    SaleAfterChat1.0,

    SaleAfterChat3.0,

    SaleAfterChat4.0,

    OrderNumber,

    OrderNumberForRules,

    OrderNumberForReports,

    OrderTotalForReports,

    DuplicateOrderNumberCounter,

    TrialPage,

    ConversionStage,

    ChatEngage,

    Section,

    product3,

    product2,

    product1,

    live_engage_control_group,

    deliveryHook_BrowsingSite,

    [engageFlagOncartpage-comingfromaffiliates(2013links)-ACADLT,InventorLT,InventorLTSuite_EnterPage],

    [engageFlagCoreUSeStorevisitors[fromUSandCA]]]_EnterSite],

    Currency,

    excludeEstoreEmea,

    ChatRule,

    ReportedChatStart,

    ReportedChatEnd,

    Browser,

    [Host IP],

    [Operating System],

    Country,

    City,

    Organization,

    [World Region],

    [Postal Code],

    [Time Zone],

    ISP,

    [Connection Type],

    [Pre-Chat Survey],

    [Exit Survey],

    [Operator Survey],

    [Offline Survey]

FROM

Demo_Chat.xlsx

(ooxml, embedded labels, table is Sheet1);

For more details on the idea of excape sequence, check here: Escape sequences

maxgro
MVP
MVP

I didn't get any errors

1.png