Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
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..
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
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;