Getting Load error

Karim_Khan — Tue, 19 Jan 2016 13:21:55 GMT

Hi Team,

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

Regards,

Re: Getting Load error

Anonymous — Tue, 19 Jan 2016 13:26:47 GMT

Check this?

Re: Getting Load error

sunny_talwar — Tue, 19 Jan 2016 13:29:30 GMT

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

Re: Getting Load error

maxgro — Tue, 19 Jan 2016 13:35:04 GMT

I didn't get any errors

topic Re: Getting Load error in QlikView

Getting Load error

Re: Getting Load error

Re: Getting Load error

Re: Getting Load error