Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I'm very new to Qlikview, I need to load multiple xls files in that need to read a specific row, could anyone of help me on this please.
thanks,
Hema
What do you mean by "specific row"?
3rd one for example?
Or
where A column = a value?
Thanks for the reply
Yes, In the file, row has data’s in row 1 row2 and row 3, in that I need only row 3 data’s in the Dashboard, I’m not much familiar in scripting so seeking for help.
Use where condition while reading the file like this?
Load
Name,
Address,
Mobile
From ExcelFile
where
Name like 'Hema*'
or
Name like '*Hema*'
or
Name like '*Hema';
Hope this will help!!
Use Where clause to filter specific rows, you need to know the filter criteria to be put in where clause.
Hi,
While posting the question in community prepare sample data and attach it, so that it would be easier to understand and provide you the solution. This way you will get the answers quickly. Please check below link for getting successful answers
Qlik Community Tip: Posting Successful Discussion Threads
You can use where condition to filter the rows, or you can use RowNo() or RecNo() in the where condition.
WHERE RowNo() = 5;
Hope this helps you.
Regards,
Jagan.
load the excel file and give the as it follows
where column name ='Hema'
HI
Try this where condition
LOAD
*
FROM ExcelFile
WHERE RowNo() <= 3;
Its seems you want to load only one column, is it?
I am assuming you are having excel file like this?
Row1, Row2, Row3
1 a aa
2 b vv
3 v bb
Now you want to load Row3 which is a column only?
Then simply write
Load
Row3
from YourExcelFile;
If I understood you correctly, you want to load row no 3.? If so,
Load *
From
[Test.xlsx]
(ooxml, embedded labels, table is Sheet1) where RecNo()=3 ;