Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Concatenate

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

1 Solution

Accepted Solutions

Re: Concatenate

Hi,

Just give space between fieldName and as keyword.

Temp_Grower_No:

LOAD Distinct [Grower No.] as Temp_Grower_No

Resident [Sales Data];

Regards,

Regards,
Prashant Sangle
6 Replies

Re: Concatenate

Hi,

Just give space between fieldName and as keyword.

Temp_Grower_No:

LOAD Distinct [Grower No.] as Temp_Grower_No

Resident [Sales Data];

Regards,

Regards,
Prashant Sangle

Re: Concatenate

Resident [Farmer Data]

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

Not applicable

Re: Concatenate

Still no luck I am afraid

MCampestrini
Valued Contributor

Re: Concatenate

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

Márcio Rodrigo Campestrini
crusader_
Valued Contributor

Re: Concatenate

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

Not applicable

Re: Concatenate

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

Community Browser