Concatenate

[#1]

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

[PrashantSangle · Accepted solution]

Hi,

Just give space between fieldName and as keyword.

Temp_Grower_No:

LOAD Distinct [Grower No.] as Temp_Grower_No

Resident [Sales Data];

Regards,

[MK_QSL]

Resident [Farmer Data]

Where NOT Exists([Grower No.],Temp_Grower_No);

[#4]

Still no luck I am afraid

[Marcio_Campestrini]

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

[crusader_]

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

[#7]

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