topic Re: Syntax in QlikView

Syntax

deepakqlikview_123 — Thu, 26 Jun 2014 08:52:14 GMT

Hi All,

Is below syntax is correct,please suggest.

Retail:

NoConcatenate

load

Resident Dealer1;

DROP Table Dealer1;

Concatenate(Retail)

LOAD * Resident EnquiryMaster;

DROP table EnquiryMaster;

Thanks,

Deepak

Re: Syntax

Anonymous — Thu, 26 Jun 2014 08:59:55 GMT

Hi,

There is nothing syntactically wrong here. I dont know your requirement. If your doubt is only about syntax then its ok. There will be no errors while reloading.

HTH

Ravi N.

Re: Syntax

Thu, 26 Jun 2014 09:12:09 GMT

Ya sure the script works fine. it will concatenate with retail ( you can see in table viewer)

but i think it will show a error like

Table not found

Concatenate(retail)

LOAD

Resident EnquiryMaster;

Re: Syntax

sasikanth — Thu, 26 Jun 2014 09:22:14 GMT

Yes

Your doing

NOconacatenate Load for RETAIL table and

below your doing concatenate with Retail table again

i think this is not correct

Re: Syntax

PradeepReddy — Thu, 26 Jun 2014 09:22:56 GMT

If the fields in the table Retail and EnquiryMaster are same then it will be throw an error.. stating that the table 'Retail' is not found.

Reason: EnquiryMaster and Dealer table are Concatenated, and Dealer table is no more exits, so no data will be copied to 'Retailer' table as consequence Retailer table won't exists.

If the fields are different in both tables, Please provide a sample script.

Re: Syntax

richard_pearce6 — Thu, 26 Jun 2014 09:30:55 GMT

Retail is loaded 'NoConcatenate' so it will load a new table even thought the fields are the same as its a load *