Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm a newbie in Qlikview and need some help.
How do I change the name of the table so I don't need to see the name "Sheet1" in the table after completed reloading the script code?
The code is:
Directory;
LOAD
A,
B,
C,
D
FROM
Downloads\test.xls
(biff, embedded labels, table is Sheet1$);
// Fullmetalboy
Hi,
Give your choice table name in above the load code like see the code
YourTableName: <--Your table name goes here.
LOAD
A,
B,
C,
D
FROM
Downloads\test.xls
(biff, embedded labels, table is Sheet1$);
Rgds
Anand
Hi,
you con add the tablename before the LOAD. In your case:
tablename:
Directory;
LOAD
...
The tablename has to be one word, otherwise you have to use [name of table].
Regards
vicky
hope this one you required
Directory;
LOAD
A,
B,
C,
D
FROM
Downloads\test.xls
(biff, embedded labels, table is Sheet1$);
Rename table Sheet1 to yourtablename ;
Hi,
Hope you got correct answer with this if so mark it correct or help ful so other can see it.
Rgds
Anand
Hi Jimmy....you can do like this....
TableName: (in case table name is of one word)
or
[Table Name] (in case you are using more than one word)
LOAD
A,
B,
C,
D
FROM
Downloads\test.xls
(biff, embedded labels, table is Sheet1$);
hope this will help you
Hi, all you need to do is instead of using Directory; , use your table name but instead of the semi colon (;), use colon(:)
TableName:
LOAD
A,
B,
C,
D
FROM
Downloads\test.xls
(biff, embedded labels, table is Sheet1$);