Primary Key

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

Hi,

I am trying to insert a primary key that I've already created into a new table, but I keep getting an error saying that the field is not found. For instance, I have a script that creates my QVDs that says this:

LOAD MEM_ID,
[Last Name],
[First Name],
[Date of Birth],
[Index Episode Start Date],
Gender,
[Readmission Date],
[Average Probability of readmission],
MEASURE_ID,
MEASURE_ID & Month(REPORT_DATE) & Year(REPORT_DATE) & DENOMINATOR & NUMERATOR & MEM_ID as _PCR2_KEY,
MEASURE_ID & Month(REPORT_DATE) & Year(REPORT_DATE) as _PCR2Calc_KEY,
NUMERATOR,
DENOMINATOR,
REPORT_DATE

It is the _PCR2Calc_KEY field that I am having trouble with. When I go to load the script in my application, I get an error saying it can't find the field:

LOAD MEM_ID,
// [Last Name],
// [First Name],
   [Date of Birth],
// [Index Episode Start Date],
   Gender,
// [Readmission Date],
   [Average Probability of readmission],
MEASURE_ID,
NUMERATOR as NUMERATOR_PCR,
DENOMINATOR as DENOMINATOR_PCR,
_PCR2_KEY,
_PCR2_CalcKEY,
Month as PCRmonth,
Year as PCRyear,
[Age at IESD]

I'm confused why there is no problem with the _PCR2_KEY field but there is an issue with the one after it. Does anyone see something I'm missing?

Thanks.

Re: Primary Key

swuehl — Fri, 10 Jun 2016 15:01:04 GMT

It depends on your input table file already containing the field or not.

Re: Primary Key

sunny_talwar — Fri, 10 Jun 2016 15:05:25 GMT

I think the field that you created is this _PCR2Calc_KEY and the field you are calling in the next load statement is this -> _PCR2_CalcKEY

Do you see the misplacement of underscore

Re: Primary Key

byrnel0586 — Fri, 10 Jun 2016 15:07:03 GMT

Oh my goodness I knew it had to be something like that, sometimes you just need a second pair of eyes! Thanks.

Re: Primary Key

sunny_talwar — Fri, 10 Jun 2016 15:10:15 GMT

Yes you do

topic Re: Primary Key in QlikView

Primary Key

Re: Primary Key

Re: Primary Key

Re: Primary Key

Re: Primary Key