Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon All,
For the life of me I just can't seem to get this code to work, I am getting the error syntax error/missing/misplaced... The code is:
[code/]
Temp_Grower_No:
LOAD Distinct [Grower No.]as Temp_Grower_No
Resident [Sales Data];
Concatenate ([Sales Data])
LOAD Distinct
[Grower No.],
'-' as Date,
'-' as [Week Day],
'-' as Year,
'-' as[Sales No.],
'-' as [Grower No.],
'-' as Name,
'-' as Bales,
'-' as Kgs,
'-' as [$/Kg],
'-' as [Sales(Gross)],
'-' as Deductions,
'-' as [Sales(Net)],
'-' as [Loan Repayment],
'-' as Payment,
'-' as [Estimated Kg],
'-' as [Estimated O/S Kgs],
'-' as [Sales(Gross) to Date],
'-' as [Hessian & Credits to Date],
'-' as [Loan($)],
'-' as [Deductions (& Debits) to Date],
'-' as [Payments to Date],
'-' as [Balance to Pay],
'2014' as Season
Resident [Farmer Data]
Where NOT Exists(Temp_Grower_No,[Grower No.]);
DROP Table Temp_Grower_No;
[code\]
Any help appreciated
H
Hi,
Just give space between fieldName and as keyword.
Temp_Grower_No:
LOAD Distinct [Grower No.] as Temp_Grower_No
Resident [Sales Data];
Regards,
Hi,
Just give space between fieldName and as keyword.
Temp_Grower_No:
LOAD Distinct [Grower No.] as Temp_Grower_No
Resident [Sales Data];
Regards,
Resident [Farmer Data]
Where NOT Exists([Grower No.],Temp_Grower_No);
Still no luck I am afraid
Hi Herbert
As I see you have the same field two times:
LOAD Distinct
[Grower No.],
'-' as Date,
'-' as [Week Day],
'-' as Year,
'-' as[Sales No.],
'-' as [Grower No.],
'-' as Name,
Maybe it help.
Márcio
Hi,
Look at your concatenation part.
You concatenate empty string to [Sales Data] table.
Field Temp_Grower_No even doesn't exists in this table, but you trying to check this Field.
If you follow Manish' solution You will check correct Field, but impossible value.
Check again your cincatenation part.
Hope this helps you.
Andrei
Thank you, problem was a space issue between as and the name of the field further down in the script.
All your help much appreciated.
H