Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What am I doing wrong here? Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items; Store Local_Individual_Items INTO C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd
OK, So this loads the file Cost_Centers into QVW, but does not create the QVD Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Cost_Centers; Store Cost_Centers INTO C:\Program Files\QlikView\LOCAL\Local_Cost_Centers.qvd (qvd); SQL SELECT * FROM dw_DataMart.dbo.Dim_Cost_Centers;
Try the following:
Cost_Centers:
LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items;
Store Cost_Centers INTO C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd);
These are the errors I received: Cannot open file 'C:\Users\uslovjon\Desktop\dw_DataMart.dbo.Dim_Individual_Items' The system cannot find the file specified. Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items Table not found Store Cost_Centers INTO C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd)
CC: LOAD Cost_Center FROM C:\Users\uslovjon\Desktop\CC.xlsx (ooxml, embedded labels, table is Sheet1); Store CC Into C:\cc.qvd (qvd); This works fine when I comment out the last line. When it is in there - I simply get "execution of script failed..."
CC: LOAD Cost_Center FROM C:\Users\uslovjon\Desktop\CC.xlsx (ooxml, embedded labels, table is Sheet1); Store CC Into C:\cc.qvd (qvd);