Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD LOC_ID,
LOC_NAME,
DEFAULT_GENDER,
DEFAULT_AREA_CODE,
DEFAULT_ZIP,
DEFAULT_FASTING,
HEADER1,
HEADER2,
HEADER3,
HEADER4,
HEADER5,
HEADER_PIC,
FOOTER1,
FOOTER2,
FOOTER3,
FOOTER4,
FOOTER5,
DEFAULT_REQ_DOCS_FLAG,
SETTINGS_MASK,
NOTES,
DEFAULT_ABN_RPT_ID,
DEFAULT_REQ_RPT_ID,
CLIA_NO,
ORG_ID,
DIRECTOR,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
PHONE,
FAX_PHONE,
EXTERNAL_NO,
SPECIMEN_CONTAINER_ID,
SPECIMEN_EXTRA_COUNT,
AUTO_PRINT_EXTRA_COPIES,
CUMULATIVE_BREAK,
EMAIL_ADDRESS,
PASSWORD,
PRINT_DEFAULT,
FAX_DEFAULT,
EMAIL_DEFAULT,
DEFAULT_PRINTER,
RPT_ID;
[LabdeqLocations]:
SELECT "LOC_ID",
"LOC_NAME",
"DEFAULT_GENDER",
"DEFAULT_AREA_CODE",
"DEFAULT_ZIP",
"DEFAULT_FASTING",
HEADER1,
HEADER2,
HEADER3,
HEADER4,
HEADER5,
"HEADER_PIC",
FOOTER1,
FOOTER2,
FOOTER3,
FOOTER4,
FOOTER5,
"DEFAULT_REQ_DOCS_FLAG",
"SETTINGS_MASK",
NOTES,
"DEFAULT_ABN_RPT_ID",
"DEFAULT_REQ_RPT_ID",
"CLIA_NO",
"ORG_ID",
DIRECTOR,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
PHONE,
"FAX_PHONE",
"EXTERNAL_NO",
"SPECIMEN_CONTAINER_ID",
"SPECIMEN_EXTRA_COUNT",
"AUTO_PRINT_EXTRA_COPIES",
"CUMULATIVE_BREAK",
"EMAIL_ADDRESS",
PASSWORD,
"PRINT_DEFAULT",
"FAX_DEFAULT",
"EMAIL_DEFAULT",
"DEFAULT_PRINTER",
"RPT_ID"
FROM "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;
store [LabdeqLocations] into 'lib://Labdaq Data:DataFiles/LabdeqLocations.qvd';
drop table LabdeqLocations;
just below is sufficient, preceding load is not required
Also, Which connector are you using? example ODBC/OLEDB/ any specific web connector?
try doing a select *
LabdeqLocations:
SQL Select * from "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;
[LabdeqLocations]:
SQL
SELECT "LOC_ID",
"LOC_NAME",
"DEFAULT_GENDER",
"DEFAULT_AREA_CODE",
"DEFAULT_ZIP",
"DEFAULT_FASTING",
HEADER1,
HEADER2,
HEADER3,
HEADER4,
HEADER5,
"HEADER_PIC",
FOOTER1,
FOOTER2,
FOOTER3,
FOOTER4,
FOOTER5,
"DEFAULT_REQ_DOCS_FLAG",
"SETTINGS_MASK",
NOTES,
"DEFAULT_ABN_RPT_ID",
"DEFAULT_REQ_RPT_ID",
"CLIA_NO",
"ORG_ID",
DIRECTOR,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
PHONE,
"FAX_PHONE",
"EXTERNAL_NO",
"SPECIMEN_CONTAINER_ID",
"SPECIMEN_EXTRA_COUNT",
"AUTO_PRINT_EXTRA_COPIES",
"CUMULATIVE_BREAK",
"EMAIL_ADDRESS",
PASSWORD,
"PRINT_DEFAULT",
"FAX_DEFAULT",
"EMAIL_DEFAULT",
"DEFAULT_PRINTER",
"RPT_ID"
FROM "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;
Just tried this and its still gave me a:
(Connector error: Status(StatusCode="Internal", Detail="Invalid row status 5 at 0"))
the connector i am using is a microsoft sql connection via qlik data gate way.
Are you generating the query with the Data Preview or are you writing the query directly ?
If you are not using the Data preview, could you go to the connection, select "select data" icon and use the preview window to generate the query ?
Thanks!