Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
paste your script/....
REFERENCE --- how this column is calculated?
This column is not calculated, it's just a reference to join one table to the other. It's equal to "yearweek"&[LM].
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';
Can you show the script where you creating this Reference field?