Solved: Re: Field Not Found - Qlik Community

rduah4u · ‎2024-08-07

BurnedTemp:
LOAD *
FROM [lib://xyz.csv]
(txt, utf8, embedded labels, delimiter is ',', msq, header is 6 lines);

FOR i = 1 TO NoOfFields('BurnedTemp')
LET vFieldName = TRIM(FieldName($(i), 'BurnedTemp'));
TRACE Field $(i): '$(vFieldName)';
NEXT

LET vDateFields = '';

FOR i = 2 TO NoOfFields('BurnedTemp')
LET vFieldName = TRIM(FieldName($(i), 'BurnedTemp'));
TRACE Checking Field: '$(vFieldName)';

IF LEFT('$(vFieldName)', 5) = '2024-' THEN
TRACE Date Field Found: $(vFieldName);
LET vDateFields = '$(vDateFields),[' & TRIM('$(vFieldName)') & ']';
ENDIF
NEXT i;

LET vDateFields = MID('$(vDateFields)', 2);
TRACE vDateFields: $(vDateFields);

IF LEN('$(vDateFields)') > 0 THEN
LET vCrossTableScript = '
BurnedDataStage:
CrossTable(Date, BurnedPoints, 1)
LOAD
" email; FirstName; LastName"
,
$(vDateFields)
RESIDENT BurnedTemp;';

TRACE vCrossTableScript: $(vCrossTableScript);

$(vCrossTableScript);
ELSE
TRACE Error: vDateFields is empty;
ENDIF

I keep getting this error message when clearly the field is being recognised??? Can someone let me know what im missing?

BurnedTemp << TestLoss Prevention_ Points burned (Clair) (2 of 3) Lines fetched: 10,000 Field 1: 'email; FirstName; LastName' Field 2: '2024-05-13' Field 3: '2024-05-14' Field 4: '2024-05-15' Field 5: '2024-05-16' Field 6: '2024-05-17' Field 7: '2024-05-18' Field 8: '2024-05-19' Field 9: '2024-05-20' Field 10: '2024-05-21' Field 11: '2024-05-22' Field 12: '2024-05-23' Field 13: '2024-05-24' Field 14: '2024-05-25' Field 15: '2024-05-26' Field 16: '2024-05-27' Field 17: '2024-05-28' Field 18: '2024-05-29' Field 19: '2024-05-30' Field 20: '2024-05-31' Field 21: '2024-06-01' Field 22: '2024-06-02' Field 23: '2024-06-03' Field 24: '2024-06-04' Field 25: '2024-06-05' Field 26: '2024-06-06' Field 27: '2024-06-07' Field 28: '2024-06-08' Field 29: '2024-06-09' Field 30: '2024-06-10' Field 31: '2024-06-11' Field 32: '2024-06-12' Field 33: '2024-06-13' Field 34: '2024-06-14' Field 35: '2024-06-15' Field 36: '2024-06-16' Field 37: '2024-06-17' Field 38: '2024-06-18' Field 39: '2024-06-19' Field 40: '2024-06-20' Field 41: '2024-06-21' Field 42: '2024-06-22' Field 43: '2024-06-23' Field 44: '2024-06-24' Field 45: '2024-06-25' Field 46: '2024-06-26' Field 47: '2024-06-27' Field 48: '2024-06-28' Field 49: '2024-06-29' Field 50: '2024-06-30' Field 51: '2024-07-01' Field 52: '2024-07-02' Field 53: '2024-07-03' Field 54: '2024-07-04' Field 55: '2024-07-05' Field 56: '2024-07-06' Field 57: '2024-07-07' Field 58: '2024-07-08' Field 59: '2024-07-09' Field 60: '2024-07-10' Field 61: '2024-07-11' Field 62: '2024-07-12' Field 63: '2024-07-13' Field 64: '2024-07-14' Field 65: '2024-07-15' Field 66: '2024-07-16' Field 67: '2024-07-17' Field 68: '2024-07-18' Field 69: '2024-07-19' Field 70: '2024-07-20' Field 71: '2024-07-21' Field 72: '2024-07-22' Field 73: '2024-07-23' Field 74: '2024-07-24' Field 75: '2024-07-25' Field 76: '2024-07-26' Field 77: '2024-07-27' Field 78: '2024-07-28' Field 79: '2024-07-29' Field 80: '2024-07-30' Field 81: '2024-07-31' Field 82: '2024-08-01' Field 83: '2024-08-02' Field 84: '2024-08-03' Field 85: '2024-08-04' Field 86: '2024-08-05' Field 87: '2024-08-06' Checking Field: '2024-05-13' Date Field Found: 2024-05-13 Checking Field: '2024-05-14' Date Field Found: 2024-05-14 Checking Field: '2024-05-15' Date Field Found: 2024-05-15 Checking Field: '2024-05-16' Date Field Found: 2024-05-16 Checking Field: '2024-05-17' Date Field Found: 2024-05-17 Checking Field: '2024-05-18' Date Field Found: 2024-05-18 Checking Field: '2024-05-19' Date Field Found: 2024-05-19 Checking Field: '2024-05-20' Date Field Found: 2024-05-20 Checking Field: '2024-05-21' Date Field Found: 2024-05-21 Checking Field: '2024-05-22' Date Field Found: 2024-05-22 Checking Field: '2024-05-23' Date Field Found: 2024-05-23 Checking Field: '2024-05-24' Date Field Found: 2024-05-24 Checking Field: '2024-05-25' Date Field Found: 2024-05-25 Checking Field: '2024-05-26' Date Field Found: 2024-05-26 Checking Field: '2024-05-27' Date Field Found: 2024-05-27 Checking Field: '2024-05-28' Date Field Found: 2024-05-28 Checking Field: '2024-05-29' Date Field Found: 2024-05-29 Checking Field: '2024-05-30' Date Field Found: 2024-05-30 Checking Field: '2024-05-31' Date Field Found: 2024-05-31 Checking Field: '2024-06-01' Date Field Found: 2024-06-01 Checking Field: '2024-06-02' Date Field Found: 2024-06-02 Checking Field: '2024-06-03' Date Field Found: 2024-06-03 Checking Field: '2024-06-04' Date Field Found: 2024-06-04 Checking Field: '2024-06-05' Date Field Found: 2024-06-05 Checking Field: '2024-06-06' Date Field Found: 2024-06-06 Checking Field: '2024-06-07' Date Field Found: 2024-06-07 Checking Field: '2024-06-08' Date Field Found: 2024-06-08 Checking Field: '2024-06-09' Date Field Found: 2024-06-09 Checking Field: '2024-06-10' Date Field Found: 2024-06-10 Checking Field: '2024-06-11' Date Field Found: 2024-06-11 Checking Field: '2024-06-12' Date Field Found: 2024-06-12 Checking Field: '2024-06-13' Date Field Found: 2024-06-13 Checking Field: '2024-06-14' Date Field Found: 2024-06-14 Checking Field: '2024-06-15' Date Field Found: 2024-06-15 Checking Field: '2024-06-16' Date Field Found: 2024-06-16 Checking Field: '2024-06-17' Date Field Found: 2024-06-17 Checking Field: '2024-06-18' Date Field Found: 2024-06-18 Checking Field: '2024-06-19' Date Field Found: 2024-06-19 Checking Field: '2024-06-20' Date Field Found: 2024-06-20 Checking Field: '2024-06-21' Date Field Found: 2024-06-21 Checking Field: '2024-06-22' Date Field Found: 2024-06-22 Checking Field: '2024-06-23' Date Field Found: 2024-06-23 Checking Field: '2024-06-24' Date Field Found: 2024-06-24 Checking Field: '2024-06-25' Date Field Found: 2024-06-25 Checking Field: '2024-06-26' Date Field Found: 2024-06-26 Checking Field: '2024-06-27' Date Field Found: 2024-06-27 Checking Field: '2024-06-28' Date Field Found: 2024-06-28 Checking Field: '2024-06-29' Date Field Found: 2024-06-29 Checking Field: '2024-06-30' Date Field Found: 2024-06-30 Checking Field: '2024-07-01' Date Field Found: 2024-07-01 Checking Field: '2024-07-02' Date Field Found: 2024-07-02 Checking Field: '2024-07-03' Date Field Found: 2024-07-03 Checking Field: '2024-07-04' Date Field Found: 2024-07-04 Checking Field: '2024-07-05' Date Field Found: 2024-07-05 Checking Field: '2024-07-06' Date Field Found: 2024-07-06 Checking Field: '2024-07-07' Date Field Found: 2024-07-07 Checking Field: '2024-07-08' Date Field Found: 2024-07-08 Checking Field: '2024-07-09' Date Field Found: 2024-07-09 Checking Field: '2024-07-10' Date Field Found: 2024-07-10 Checking Field: '2024-07-11' Date Field Found: 2024-07-11 Checking Field: '2024-07-12' Date Field Found: 2024-07-12 Checking Field: '2024-07-13' Date Field Found: 2024-07-13 Checking Field: '2024-07-14' Date Field Found: 2024-07-14 Checking Field: '2024-07-15' Date Field Found: 2024-07-15 Checking Field: '2024-07-16' Date Field Found: 2024-07-16 Checking Field: '2024-07-17' Date Field Found: 2024-07-17 Checking Field: '2024-07-18' Date Field Found: 2024-07-18 Checking Field: '2024-07-19' Date Field Found: 2024-07-19 Checking Field: '2024-07-20' Date Field Found: 2024-07-20 Checking Field: '2024-07-21' Date Field Found: 2024-07-21 Checking Field: '2024-07-22' Date Field Found: 2024-07-22 Checking Field: '2024-07-23' Date Field Found: 2024-07-23 Checking Field: '2024-07-24' Date Field Found: 2024-07-24 Checking Field: '2024-07-25' Date Field Found: 2024-07-25 Checking Field: '2024-07-26' Date Field Found: 2024-07-26 Checking Field: '2024-07-27' Date Field Found: 2024-07-27 Checking Field: '2024-07-28' Date Field Found: 2024-07-28 Checking Field: '2024-07-29' Date Field Found: 2024-07-29 Checking Field: '2024-07-30' Date Field Found: 2024-07-30 Checking Field: '2024-07-31' Date Field Found: 2024-07-31 Checking Field: '2024-08-01' Date Field Found: 2024-08-01 Checking Field: '2024-08-02' Date Field Found: 2024-08-02 Checking Field: '2024-08-03' Date Field Found: 2024-08-03 Checking Field: '2024-08-04' Date Field Found: 2024-08-04 Checking Field: '2024-08-05' Date Field Found: 2024-08-05 Checking Field: '2024-08-06' Date Field Found: 2024-08-06 vDateFields: [2024-05-13],[2024-05-14],[2024-05-15],[2024-05-16],[2024-05-17],[2024-05-18],[2024-05-19],[2024-05-20],[2024-05-21],[2024-05-22],[2024-05-23],[2024-05-24],[2024-05-25],[2024-05-26],[2024-05-27],[2024-05-28],[2024-05-29],[2024-05-30],[2024-05-31],[2024-06-01],[2024-06-02],[2024-06-03],[2024-06-04],[2024-06-05],[2024-06-06],[2024-06-07],[2024-06-08],[2024-06-09],[2024-06-10],[2024-06-11],[2024-06-12],[2024-06-13],[2024-06-14],[2024-06-15],[2024-06-16],[2024-06-17],[2024-06-18],[2024-06-19],[2024-06-20],[2024-06-21],[2024-06-22],[2024-06-23],[2024-06-24],[2024-06-25],[2024-06-26],[2024-06-27],[2024-06-28],[2024-06-29],[2024-06-30],[2024-07-01],[2024-07-02],[2024-07-03],[2024-07-04],[2024-07-05],[2024-07-06],[2024-07-07],[2024-07-08],[2024-07-09],[2024-07-10],[2024-07-11],[2024-07-12],[2024-07-13],[2024-07-14],[2024-07-15],[2024-07-16],[2024-07-17],[2024-07-18],[2024-07-19],[2024-07-20],[2024-07-21],[2024-07-22],[2024-07-23],[2024-07-24],[2024-07-25],[2024-07-26],[2024-07-27],[2024-07-28],[2024-07-29],[2024-07-30],[2024-07-31],[2024-08-01],[2024-08-02],[2024-08-03],[2024-08-04],[2024-08-05],[2024-08-06] vCrossTableScript: BurnedDataStage: CrossTable(Date, BurnedPoints, 1) LOAD " email; FirstName; LastName" , [2024-05-13],[2024-05-14],[2024-05-15],[2024-05-16],[2024-05-17],[2024-05-18],[2024-05-19],[2024-05-20],[2024-05-21],[2024-05-22],[2024-05-23],[2024-05-24],[2024-05-25],[2024-05-26],[2024-05-27],[2024-05-28],[2024-05-29],[2024-05-30],[2024-05-31],[2024-06-01],[2024-06-02],[2024-06-03],[2024-06-04],[2024-06-05],[2024-06-06],[2024-06-07],[2024-06-08],[2024-06-09],[2024-06-10],[2024-06-11],[2024-06-12],[2024-06-13],[2024-06-14],[2024-06-15],[2024-06-16],[2024-06-17],[2024-06-18],[2024-06-19],[2024-06-20],[2024-06-21],[2024-06-22],[2024-06-23],[2024-06-24],[2024-06-25],[2024-06-26],[2024-06-27],[2024-06-28],[2024-06-29],[2024-06-30],[2024-07-01],[2024-07-02],[2024-07-03],[2024-07-04],[2024-07-05],[2024-07-06],[2024-07-07],[2024-07-08],[2024-07-09],[2024-07-10],[2024-07-11],[2024-07-12],[2024-07-13],[2024-07-14],[2024-07-15],[2024-07-16],[2024-07-17],[2024-07-18],[2024-07-19],[2024-07-20],[2024-07-21],[2024-07-22],[2024-07-23],[2024-07-24],[2024-07-25],[2024-07-26],[2024-07-27],[2024-07-28],[2024-07-29],[2024-07-30],[2024-07-31],[2024-08-01],[2024-08-02],[2024-08-03],[2024-08-04],[2024-08-05],[2024-08-06] RESIDENT BurnedTemp

The following error occurred:

Field '2024-05-13' not found

The error occurred here:

BurnedDataStage: CrossTable(Date, BurnedPoints, 1) LOAD " email; FirstName; LastName" , [2024-05-13],[2024-05-14],[2024-05-15],[2024-05-16],[2024-05-17],[2024-05-18],[2024-05-19],[2024-05-20],[2024-05-21],[2024-05-22],[2024-05-23],[2024-05-24],[2024-05-25],[2024-05-26],[2024-05-27],[2024-05-28],[2024-05-29],[2024-05-30],[2024-05-31],[2024-06-01],[2024-06-02],[2024-06-03],[2024-06-04],[2024-06-05],[2024-06-06],[2024-06-07],[2024-06-08],[2024-06-09],[2024-06-10],[2024-06-11],[2024-06-12],[2024-06-13],[2024-06-14],[2024-06-15],[2024-06-16],[2024-06-17],[2024-06-18],[2024-06-19],[2024-06-20],[2024-06-21],[2024-06-22],[2024-06-23],[2024-06-24],[2024-06-25],[2024-06-26],[2024-06-27],[2024-06-28],[2024-06-29],[2024-06-30],[2024-07-01],[2024-07-02],[2024-07-03],[2024-07-04],[2024-07-05],[2024-07-06],[2024-07-07],[2024-07-08],[2024-07-09],[2024-07-10],[2024-07-11],[2024-07-12],[2024-07-13],[2024-07-14],[2024-07-15],[2024-07-16],[2024-07-17],[2024-07-18],[2024-07-19],[2024-07-20],[2024-07-21],[2024-07-22],[2024-07-23],[2024-07-24],[2024-07-25],[2024-07-26],[2024-07-27],[2024-07-28],[2024-07-29],[2024-07-30],[2024-07-31],[2024-08-01],[2024-08-02],[2024-08-03],[2024-08-04],[2024-08-05],[2024-08-06] RESIDENT BurnedTemp

rwunderlich · ‎2024-08-07

I notice you are using Trim() against the field name. Are you sure you should be doing that?

TRIM('$(vFieldName)')

-Rob

View solution in original post

rwunderlich · ‎2024-08-07

I notice you are using Trim() against the field name. Are you sure you should be doing that?

TRIM('$(vFieldName)')

-Rob