Saving into .CSV file from multiple tables, fails on join/concatenate

[Anonymous]

Hi,

i have the below script to save few fields into .csv file.

It fails on left join/ join/concatenate Error: Table not found

Can you please help me fix this.

Let vRunMonth = month(today());

IF vRunMonth = 'Jan' then

LET vYear =  year(today()) - 1;

ELSE

LET vYear =  year(today());

ENDIF;

Opex:

Load

   [COPE Fiscal Year_GJAHR],

   [Period_PERIO],

   [Cost Element_KSTAR],

   [Company Code_BUKRS],

   [Object number_OBJNR],    

   [Transaction Currency_TWAER],

   [Value in Obj. Crcy_WOGBTR],

   [PO Category_RBEST]

Resident [COEP CO Object: Line Items (by Period)]

Where [COPE Fiscal Year_GJAHR] = $(vYear) and match([Company Code_BUKRS],1000,2000,3000,5000,7600,8600,8800,8900,9500,9600,9700); 

Concatenate(Opex)

Load

   [Object number_OBJNR],

   [Cost Center_KOSTL]

Resident [CSKS Cost Center Master Data]

Where exists([Object number_OBJNR],[Object number_OBJNR]);

//-------------------Load into .CSV file------------------------//

OpexCSV:

Load

[COPE Fiscal Year_GJAHR],

[Period_PERIO],

[Cost Element_KSTAR],

[Cost Center_KOSTL],

[Transaction Currency_TWAER]

Resident Opex;

STORE OpexCSV INTO [XYZ\Hyperion Opex.csv] (txt);

DROP TABLES Opex,OpexCSV;

Thanks!

[chaper]

Where are these tables in script [COEP CO Object: Line Items (by Period)] or [CSKS Cost Center Master Data]?Are they already preloaded before concatenation as you mentioned Resident??Above script is complete script or only some of it?

[Anonymous]

I have loaded [COEP CO Object: Line Items (by Period)] & [CSKS Cost Center Master Data] tables in the script and then did a resident and concatenating them...

I posted part of the script where i have the issue..

[Peter_Cammaert]

Use the Table Viewer (Ctrl-T) to check whether table OpexCSV really exists. If it doesn't, you're the victim of QlikView's AutoConcatenate behavior.

In that case, simply add the NOCONCATENATE prefix to the OpexCSV LOAD statement and reload again.

Peter

[chaper]

Add Noconcatenate before load into .csv file Script

Noconcatenate

//-------------------Load into .CSV file------------------------//

OpexCSV:

Load

[COPE Fiscal Year_GJAHR],

[Period_PERIO],

[Cost Element_KSTAR],

[Cost Center_KOSTL],

[Transaction Currency_TWAER]

Resident Opex;

STORE OpexCSV INTO [XYZ\Hyperion Opex.csv] (txt);

DROP TABLES Opex,OpexCSV;