Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
melissa_esl
New Contributor

Error when loading data - field not found

Hello,

I am getting an error when loading my data and I am not able to determine why/where the error comes from as it just mentioned a field is not found but as it occurred in "?".  

10:37:57 A
?

 

10:37:26 A
Output cleared.
10:37:57 A
---
10:37:57 A
Started loading data
10:37:57 A
---
10:37:57 A
Sheet1
10:37:57 A
Lines fetched: 214
10:37:57 A
ESL BE - Qlik << ESL BE - Qlik
10:37:57 A
Lines fetched: 252
10:37:57 A
ESL BE - Qlik << ESL BE - Qlik
10:37:57 A
Lines fetched: 3,024
10:37:57 A
ESL SA - Qlik << ESL SA - Qlik
10:37:57 A
Lines fetched: 2,362
10:37:57 A
ESL SA - Qlik << ESL SA - Qlik
10:37:57 A
Lines fetched: 28,344
10:37:57 A
ESL NL - Qlik << ESL NL - Qlik
10:37:57 A
Lines fetched: 184
10:37:57 A
ESL BE - Qlik << ESL NL - Qlik
10:37:57 A
Lines fetched: 5,232
10:37:57 A
ESL DE - Qlik << ESL DE - Qlik
10:37:57 A
Lines fetched: 565
10:37:57 A
ESL BE - Qlik << ESL DE - Qlik
10:37:57 A
Lines fetched: 12,012
10:37:57 A
ESL FR - Qlik << ESL FR - Qlik
10:37:57 A
Lines fetched: 552
10:37:57 A
ESL BE - Qlik << ESL FR - Qlik
10:37:57 A
Lines fetched: 18,636
10:37:57 A
ESL ES - Qlik << ESL ES - Qlik
10:37:57 A
Lines fetched: 515
10:37:57 A
ESL BE - Qlik << ESL ES - Qlik
10:37:57 A
Lines fetched: 24,816
10:37:57 A
ESL IT - Qlik << ESL IT - Qlik
10:37:57 A
Lines fetched: 396
10:37:57 A
ESL BE - Qlik << ESL IT - Qlik
10:37:57 A
Lines fetched: 29,568
10:37:57 A
ESL ITSSC - Qlik << ESL ITSSC - Qlik
10:37:57 A
Lines fetched: 59
10:37:57 A
ESL BE - Qlik << ESL ITSSC - Qlik
10:37:57 A
Lines fetched: 30,276
10:37:57 A
ESL AT - Qlik << ESL AT - Qlik
10:37:57 A
Lines fetched: 188
10:37:57 A
ESL BE - Qlik << ESL AT - Qlik
10:37:57 A
Lines fetched: 32,532
10:37:57 A
ESL UK - Qlik << ESL UK - Qlik
10:37:57 A
Lines fetched: 200
10:37:57 A
ESL UK - Qlik << ESL UK - Qlik
10:37:57 A
Lines fetched: 2,400
10:37:57 A
ESL SE - Qlik << ESL SE - Qlik
10:37:57 A
Lines fetched: 177
10:37:57 A
ESL SE - Qlik << ESL SE - Qlik
10:37:57 A
Lines fetched: 2,124
10:37:57 A
ESL CO - Qlik << ESL CO - Qlik
10:37:57 A
Lines fetched: 24
10:37:57 A
ESL CO - Qlik << ESL CO - Qlik
10:37:57 A
Lines fetched: 288
10:37:57 A
ESL PA - Qlik << ESL PA - Qlik
10:37:57 A
Lines fetched: 27
10:37:57 A
ESL PA - Qlik << ESL PA - Qlik
10:37:57 A
Lines fetched: 324
10:37:57 A
ESL SA AC3_2017 - Qlik << ESL SA AC3_2017 - Qlik
10:37:57 A
Lines fetched: 2,427
10:37:57 A
ESL SA17 - Qlik << ESL SA AC3_2017 - Qlik
10:37:57 A
Lines fetched: 21,843
10:37:57 A
ESL BHQ AC3_2017 - Qlik << ESL BHQ AC3_2017 - Qlik
10:37:57 A
Lines fetched: 448
10:37:57 A
ESL BHQ 2017 - Qlik << ESL BHQ AC3_2017 - Qlik
10:37:57 A
Lines fetched: 1,344
10:37:57 A
ESL ITSSC AC3_2017 - Qlik << ESL ITSSC AC3_2017 - Qlik
10:37:57 A
Lines fetched: 67
10:37:57 A
ESL BHQ 2017 - Qlik << ESL ITSSC AC3_2017 - Qlik
10:37:57 A
Lines fetched: 1,947
10:37:57 A
ESL AT AC3_2017 - Qlik << ESL AT AC3_2017 - Qlik
10:37:57 A
Lines fetched: 198
10:37:57 A
ESL BHQ 2017 - Qlik << ESL AT AC3_2017 - Qlik
10:37:57 A
Lines fetched: 3,729
10:37:57 A
ESL BE AC3_2017 - Qlik << ESL BE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 264
10:37:57 A
ESL BHQ 2017 - Qlik << ESL BE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 6,105
10:37:57 A
ESL DE AC3_2017 - Qlik << ESL DE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 608
10:37:57 A
ESL BHQ 2017 - Qlik << ESL DE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 11,577
10:37:57 A
ESL ES AC3_2017 - Qlik << ESL ES AC3_2017 - Qlik
10:37:57 A
Lines fetched: 556
10:37:57 A
ESL BHQ 2017 - Qlik << ESL ES AC3_2017 - Qlik
10:37:57 A
Lines fetched: 16,581
10:37:57 A
ESL FR AC3_2017 - Qlik << ESL FR AC3_2017 - Qlik
10:37:57 A
Lines fetched: 651
10:37:57 A
ESL BHQ 2017 - Qlik << ESL FR AC3_2017 - Qlik
10:37:57 A
Lines fetched: 22,440
10:37:57 A
ESL IT AC3_2017 - Qlik << ESL IT AC3_2017 - Qlik
10:37:57 A
Lines fetched: 433
10:37:57 A
ESL BHQ 2017 - Qlik << ESL IT AC3_2017 - Qlik
10:37:57 A
Lines fetched: 26,337
10:37:57 A
ESL NC AC3_2017 - Qlik << ESL NC AC3_2017 - Qlik
10:37:57 A
Lines fetched: 178
10:37:57 A
ESL BHQ 2017 - Qlik << ESL NC AC3_2017 - Qlik
10:37:57 A
Lines fetched: 27,939
10:37:57 A
ESL NL AC3_2017 - Qlik << ESL NL AC3_2017 - Qlik
10:37:57 A
Lines fetched: 192
10:37:57 A
ESL BHQ 2017 - Qlik << ESL NL AC3_2017 - Qlik
10:37:57 A
Lines fetched: 29,667
10:37:57 A
ESL CO AC3_2017 - Qlik << ESL CO AC3_2017 - Qlik
10:37:57 A
Lines fetched: 187
10:37:57 A
ESL CO17 - Qlik << ESL CO AC3_2017 - Qlik
10:37:57 A
Lines fetched: 1,683
10:37:57 A
ESL PA AC3_2017 - Qlik << ESL PA AC3_2017 - Qlik
10:37:57 A
Lines fetched: 24
10:37:57 A
ESL PA17 - Qlik << ESL PA AC3_2017 - Qlik
10:37:57 A
Lines fetched: 216
10:37:57 A
ESL SE AC3_2017 - Qlik << ESL SE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 183
10:37:57 A
ESL SE17 - Qlik << ESL SE AC3_2017 - Qlik
10:37:57 A
Lines fetched: 1,647
10:37:57 A
ESL UK AC3_2017 - Qlik << ESL UK AC3_2017 - Qlik
10:37:57 A
Lines fetched: 208
10:37:57 A
ESL UK17 - Qlik << ESL UK AC3_2017 - Qlik
10:37:57 A
Lines fetched: 1,872
10:37:57 A
ESL SA AC3_2018 - Qlik << ESL SA AC3_2018 - Qlik
10:37:57 A
Lines fetched: 3,166
10:37:57 A
ESL SA18 - Qlik << ESL SA AC3_2018 - Qlik
10:37:57 A
Lines fetched: 28,494
10:37:57 A
ESL BHQ AC3_2018 - Qlik << ESL BHQ AC3_2018 - Qlik
10:37:57 A
Lines fetched: 462
10:37:57 A
ESL BHQ 2018 - Qlik << ESL BHQ AC3_2018 - Qlik
10:37:57 A
Lines fetched: 4,158
10:37:57 A
ESL ITSSC AC3_2018 - Qlik << ESL ITSSC AC3_2018 - Qlik
10:37:57 A
Lines fetched: 69
10:37:57 A
ESL BHQ 2018 - Qlik << ESL ITSSC AC3_2018 - Qlik
10:37:57 A
Lines fetched: 4,779
10:37:57 A
ESL AT AC3_2018 - Qlik << ESL AT AC3_2018 - Qlik
10:37:57 A
Lines fetched: 200
10:37:57 A
ESL BHQ 2018 - Qlik << ESL AT AC3_2018 - Qlik
10:37:57 A
Lines fetched: 6,579
10:37:57 A
ESL BE AC3_2018 - Qlik << ESL BE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 273
10:37:57 A
ESL BHQ 2018 - Qlik << ESL BE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 9,036
10:37:57 A
ESL DE AC3_2018 - Qlik << ESL DE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 628
10:37:57 A
ESL BHQ 2018 - Qlik << ESL DE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 14,688
10:37:57 A
ESL ES AC3_2018 - Qlik << ESL ES AC3_2018 - Qlik
10:37:57 A
Lines fetched: 627
10:37:57 A
ESL BHQ 2018 - Qlik << ESL ES AC3_2018 - Qlik
10:37:57 A
Lines fetched: 20,331
10:37:57 A
ESL FR AC3_2018 - Qlik << ESL FR AC3_2018 - Qlik
10:37:57 A
Lines fetched: 706
10:37:57 A
ESL BHQ 2018 - Qlik << ESL FR AC3_2018 - Qlik
10:37:57 A
Lines fetched: 26,685
10:37:57 A
ESL IT AC3_2018 - Qlik << ESL IT AC3_2018 - Qlik
10:37:57 A
Lines fetched: 467
10:37:57 A
ESL BHQ 2018 - Qlik << ESL IT AC3_2018 - Qlik
10:37:57 A
Lines fetched: 30,888
10:37:57 A
ESL NC AC3_2018 - Qlik << ESL NC AC3_2018 - Qlik
10:37:57 A
Lines fetched: 191
10:37:57 A
ESL BHQ 2018 - Qlik << ESL NC AC3_2018 - Qlik
10:37:57 A
Lines fetched: 32,607
10:37:57 A
ESL NL AC3_2018 - Qlik << ESL NL AC3_2018 - Qlik
10:37:57 A
Lines fetched: 197
10:37:57 A
ESL BHQ 2018 - Qlik << ESL NL AC3_2018 - Qlik
10:37:57 A
Lines fetched: 34,380
10:37:57 A
ESL CO AC3_2018 - Qlik << ESL CO AC3_2018 - Qlik
10:37:57 A
Lines fetched: 158
10:37:57 A
ESL CO18 - Qlik << ESL CO AC3_2018 - Qlik
10:37:57 A
Lines fetched: 1,422
10:37:57 A
ESL PA AC3_2018 - Qlik << ESL PA AC3_2018 - Qlik
10:37:57 A
Lines fetched: 27
10:37:57 A
ESL PA18 - Qlik << ESL PA AC3_2018 - Qlik
10:37:57 A
Lines fetched: 243
10:37:57 A
ESL SE AC3_2018 - Qlik << ESL SE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 187
10:37:57 A
ESL SE18 - Qlik << ESL SE AC3_2018 - Qlik
10:37:57 A
Lines fetched: 1,683
10:37:57 A
ESL UK AC3_2018 - Qlik << ESL UK AC3_2018 - Qlik
10:37:57 A
Lines fetched: 212
10:37:57 A
ESL UK18 - Qlik << ESL UK AC3_2018 - Qlik
10:37:57 A
Lines fetched: 1,908
10:37:57 A
ESL SA AC4_2018 - Qlik << ESL SA AC4_2018 - Qlik
10:37:57 A
Lines fetched: 3,231
10:37:57 A
ESL SA18 - Qlik-1 << ESL SA AC4_2018 - Qlik
10:37:57 A
Lines fetched: 38,772
10:37:57 A
ESL BHQ AC4_2018 - Qlik << ESL BHQ AC4_2018 - Qlik
10:37:57 A
Lines fetched: 473
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL BHQ AC4_2018 - Qlik
10:37:57 A
Lines fetched: 5,676
10:37:57 A
ESL ITSSC AC4_2018 - Qlik << ESL ITSSC AC4_2018 - Qlik
10:37:57 A
Lines fetched: 73
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL ITSSC AC4_2018 - Qlik
10:37:57 A
Lines fetched: 6,552
10:37:57 A
ESL AT AC4_2018 - Qlik << ESL AT AC4_2018 - Qlik
10:37:57 A
Lines fetched: 204
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL AT AC4_2018 - Qlik
10:37:57 A
Lines fetched: 9,000
10:37:57 A
ESL BE AC4_2018 - Qlik << ESL BE AC4_2018 - Qlik
10:37:57 A
Lines fetched: 277
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL BE AC4_2018 - Qlik
10:37:57 A
Lines fetched: 12,324
10:37:57 A
ESL DE AC4_2018 - Qlik << ESL DE AC4_2018 - Qlik
10:37:57 A
Lines fetched: 637
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL DE AC4_2018 - Qlik
10:37:57 A
Lines fetched: 19,968
10:37:57 A
ESL ES AC4_2018 - Qlik << ESL ES AC4_2018 - Qlik
10:37:57 A
Lines fetched: 637
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL ES AC4_2018 - Qlik
10:37:57 A
Lines fetched: 27,612
10:37:57 A
ESL FR AC4_2018 - Qlik << ESL FR AC4_2018 - Qlik
10:37:57 A
Lines fetched: 718
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL FR AC4_2018 - Qlik
10:37:57 A
Lines fetched: 36,228
10:37:57 A
ESL IT AC4_2018 - Qlik << ESL IT AC4_2018 - Qlik
10:37:57 A
Lines fetched: 483
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL IT AC4_2018 - Qlik
10:37:57 A
Lines fetched: 42,024
10:37:57 A
ESL NC AC4_2018 - Qlik << ESL NC AC4_2018 - Qlik
10:37:57 A
Lines fetched: 197
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL NC AC4_2018 - Qlik
10:37:57 A
Lines fetched: 44,388
10:37:57 A
ESL NL AC4_2018 - Qlik << ESL NL AC4_2018 - Qlik
10:37:57 A
Lines fetched: 202
10:37:57 A
ESL BHQ 2018 - Qlik-1 << ESL NL AC4_2018 - Qlik
10:37:57 A
Lines fetched: 46,812
10:37:57 A
---
10:37:57 A
The following error occurred:
10:37:57 A
Field 'Cost Center' not found
10:37:57 A
---
10:37:57 A
The error occurred here:
10:37:57 A
?
10:37:57 A
---
10:37:57 A
Data has not been loaded. Please correct the error and try loading again.
1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Error when loading data - field not found

It will be hard telling without seeing the script. It seems there is no field name 'Cost Center'. Please search for this field in script editor check if there is any mistake in spelling or any unwanted charterer present there or if that present in the source table/qvd or not.
Learning never stops.
2 Replies
pradosh_thakur
Honored Contributor II

Re: Error when loading data - field not found

It will be hard telling without seeing the script. It seems there is no field name 'Cost Center'. Please search for this field in script editor check if there is any mistake in spelling or any unwanted charterer present there or if that present in the source table/qvd or not.
Learning never stops.
melissa_esl
New Contributor

Re: Error when loading data - field not found

 

Thank you!!! I've checked everything and it is now working... caps sensitivity was my problem!