Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Script erro

Could someone help me fix this script problem?

qlik_erro.PNG

**Message Translated**

Upload started
CADASTRO << CADASTRO
Lines searched: 214,160
RUP_LOJAS_eb1fec8b-ecf0-d9b9-5e72-63b890df << RUP_LOJAS
Lines searched: 598,813
RUP_LOJAS_eb1fec8b-ecf0-d9b9-5e72-63b890df << RUP_LOJAS
Lines searched: 1,224,741
The following errors occurred:
Field 'REFERENCE' not found
The error occurred here:
?
Data not loaded. Please resolve the error and try loading again.


Picture of the join:

qlik_join_S31.PNG


Thanks

4 Replies
Chanty4u
MVP
MVP

paste your script/....

REFERENCE    --- how this column is calculated?

Anonymous
Not applicable
Author

This column is not calculated, it's just a reference to join one table to the other. It's equal to "yearweek"&[LM].

Anonymous
Not applicable
Author

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET CreateSearchIndexOnReload=1;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

vishsaggi
Champion III
Champion III

Can you show the script where you creating this Reference field?