topic Re: Script erro in QlikView

Script erro

Anonymous — Fri, 10 Aug 2018 12:59:26 GMT

Could someone help me fix this script problem?

**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:

Thanks

Re: Script erro

Chanty4u — Fri, 10 Aug 2018 16:13:45 GMT

paste your script/....

REFERENCE --- how this column is calculated?

Re: Script erro

Anonymous — Fri, 10 Aug 2018 16:53:14 GMT

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

Re: Script erro

Anonymous — Fri, 10 Aug 2018 16:58:59 GMT

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';

Re: Script erro

vishsaggi — Fri, 10 Aug 2018 17:47:31 GMT

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