topic Re: How to Omit text/certain data? in QlikView

How to Omit text/certain data?

Fri, 21 Dec 2012 05:35:24 GMT

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

Re: How to Omit text/certain data?

Fri, 21 Dec 2012 05:49:06 GMT

Hello,

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

Re: How to Omit text/certain data?

Fri, 21 Dec 2012 06:03:20 GMT

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

Re: How to Omit text/certain data?

jagan — Fri, 21 Dec 2012 06:18:23 GMT

Hi,

Please find attached files hope it helps you.

Regards,

Jagan.

Re: How to Omit text/certain data?

Fri, 21 Dec 2012 07:01:59 GMT

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

Re: How to Omit text/certain data?

jagan — Fri, 21 Dec 2012 07:22:50 GMT

Hi,

Check this script and excel file for sample data

Directory;

LOAD

RowNo() AS RowNo,

FROM

TestData.xlsx

(ooxml, embedded labels, table is Sheet1)

where A <> 'A';

Regards,

Jagan.

Re: How to Omit text/certain data?

Fri, 21 Dec 2012 10:53:57 GMT

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

Re: How to Omit text/certain data?

Fri, 21 Dec 2012 11:04:28 GMT

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

Re: How to Omit text/certain data?

jagan — Fri, 21 Dec 2012 11:17:15 GMT

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.