How to load the range of rows of an excel sheet?

[#1]

Hi All,

I have an excel sheet with 3 differant datasets in differant ranges.

Now how can i specify the range of data to load any particular data of the excel file into qlikview ?

For your referance,Please check the attachment.

Thanks for any help..

Regards

Kumar

[udit_kumar_sana]

Hi,

Please find here the attached file for the solution.

Regards,

Udit

[#3 · Accepted solution]

Hi,

You can use transformation steps which are availble during loading of excel sheet.

Regards,

Amay

[#4]

Hi,

If you know the start and the end point of the data set. you can get the data fo the data set.

please check out the file attached.

Thanks,

Sampath