table not found error; the table is there and loads data rows ...

wynnjimbbt — Wed, 25 Nov 2020 16:16:04 GMT

Below is the end of my load script with error Error: Table 'EmployeeCostCenterDG111' not found.

I have tried everything I know to do, the 111 in the table name is just for troubleshooting.

Has anybody got a work around or a fix? I used Find in the script editor to verify the table names are exactly the same.

2018-09-21 15:21:14 2706 EmployeeCostCenterDG111:

2018-09-21 15:21:14 2707 LOAD

2018-09-21 15:21:14 2708 AutoNumber(OfficerNbr & '-' & [Assignment Start Date], 'EmployeeCenterKey') as EmployeeCenterKey,

2018-09-21 15:21:14 2709 *

2018-09-21 15:21:14 2710

2018-09-21 15:21:14 2711 LOAD

2018-09-21 15:21:14 2712 OfficerNbr,

2018-09-21 15:21:14 2713 EffectiveDate as [Assignment Start Date],

2018-09-21 15:21:14 2714

2018-09-21 15:21:14 2715

2018-09-21 15:21:14 2716 if( OfficerNbr = peek('OfficerNbr'),date(peek('Assignment Start Date')-1), if(not isnull(EmployeeEndDate), Today(), AddMonths(Today(),15))) as [Assignment End Date],

2018-09-21 15:21:14 2717 [Cost Center]

2018-09-21 15:21:14 2718 RESIDENT Temp_EmployeeCostCenter

2018-09-21 15:21:14 2719 Where isnull(EmployeeEndDate) or (not isnull(EmployeeEndDate) and (EffectiveDate < EmployeeEndDate))

2018-09-21 15:21:14 2720 Order By OfficerNbr, EffectiveDate DESC

2018-09-21 15:21:14 5 fields found: EmployeeCenterKey, OfficerNbr, Assignment Start Date, Assignment End Date, Cost Center,

2018-09-21 15:21:14 2,884 lines fetched

2018-09-21 15:21:14 2745 Temp_DGdate_Match:

2018-09-21 15:21:14 2746 IntervalMatch ([DGdate],OfficerNbr) LOAD

2018-09-21 15:21:14 2747 [Assignment Start Date],

2018-09-21 15:21:14 2748 [Assignment End Date],

2018-09-21 15:21:14 2749 OfficerNbr

2018-09-21 15:21:14 2750 RESIDENT EmployeeCostCenterDG111

2018-09-21 15:21:14 Error: Table 'EmployeeCostCenterDG111' not found

2018-09-21 15:21:54 Execution Failed

2018-09-21 15:21:54 Execution finished.

Re: table not found error; the table is there and loads data rows ...

trdandamudi — Fri, 21 Sep 2018 19:34:51 GMT

As we do not see the entire script, My guess is you are concatenating "EmployeeCostCenterDG111" into the prior table. Once it is concatenated into the prior table that table is not available and that is the reason you are getting that error. I think you need "NoConcatenate" like below:

Noconcatenate

EmployeeCostCenterDG111:

...

Re: table not found error; the table is there and loads data rows ...

vishsaggi — Fri, 21 Sep 2018 19:42:28 GMT

Can you share the script you are trying to run? Are you using any joins in your tables where DG111 is getting joined?

topic Re: table not found error; the table is there and loads data rows ... in QlikView

table not found error; the table is there and loads data rows ...

Re: table not found error; the table is there and loads data rows ...

Re: table not found error; the table is there and loads data rows ...