How to Omit text/certain data?

[#1]

Hi All,

I have data in excel and have columns date, description, debit, credit, balance and respective data underneath. Theses headers are repeating after every page and so loading one extra row in QV. I only want actual dates, description, etc and not these headers. I can label column A, B, C as these headers.

BR,

SAK

[#2]

Hello,

Use Data Transformation Option which Comes when creating qvd,There you need to select the row and then deleteit

[#3]

the headers are repeating. and I take data in excel format from source on weekly basis. so it's headache to go to tables and load again and again all files. I just want that I keep copying in one folder all weekly files and then can load all thru script.

Need some other solution.

Thanks

[jagan]

Hi,

Please find attached files hope it helps you.

Regards,

Jagan.

[#5]

Thanks jagan. I hav PE. cant open QVW. can u plz paste script here.

[jagan · Accepted solution]

Hi,

Check this script and excel file for sample data

Directory;

LOAD

    RowNo() AS RowNo,

    A,

     B,

     C

FROM

TestData.xlsx

(ooxml, embedded labels, table is Sheet1)

where A <> 'A';

Regards,

Jagan.

[#7]

Hi Jagan

Can you please give me some link to read about all types of load and when which one should be used and which one is effiecient in which cases?

Thanks a lot buddy!

BR,

SAK

[#8]

If I want to load bank statement direct from saved web page, as it would give reliance in data to manager, how I can do that. It has several tables where the actual data resides. All compnay and account details is coming after every page and then there is separate tables where the bank statement is Date, Desc, debit, credit, balance.

Can you please advise how we can load all the tables in one go? Then I can try to omit blank and other text cells as did above.

Excel file is attached after omitting company details and transactions detail. In web data looks like this.

BR,

SAK

[jagan]

HI,

You can check the qlikview file and community for all types of load like

- Resident load

- Semantic Load

- Hierarchical Load

- Generic Load

- Cross Table

- Bundle Load

- Info Load

- Preceding Load

- Binary Load

etc. 

Almost all answers you can find in Qlikview Help file.  Hope this helps you.

Regards,

Jagan.