topic Re: Concatenate in QlikView

Concatenate

Tue, 23 Sep 2014 12:46:49 GMT

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

Re: Concatenate

PrashantSangle — Tue, 23 Sep 2014 12:49:42 GMT

Hi,

Just give space between fieldName and as keyword.

Temp_Grower_No:

LOAD Distinct [Grower No.] as Temp_Grower_No

Resident [Sales Data];

Regards,

Re: Concatenate

MK_QSL — Tue, 23 Sep 2014 12:50:14 GMT

Resident [Farmer Data]

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

Re: Concatenate

Tue, 23 Sep 2014 13:33:10 GMT

Still no luck I am afraid

Re: Concatenate

Marcio_Campestrini — Tue, 23 Sep 2014 13:46:12 GMT

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

Re: Concatenate

crusader_ — Tue, 23 Sep 2014 13:47:51 GMT

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

Re: Concatenate

Wed, 24 Sep 2014 08:01:32 GMT

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.