topic Re: Need Help in QlikView

Need Help

paulwalker — Sat, 02 Jan 2016 05:48:29 GMT

Hi Community,

I have excel data source, but i have junk text in Excel sheet..

Tools	Category Name	Cat Cost
	Category	Cost
Sql Server	A	3000	Sql Cost
Tableau	B	1000	Tableau cost
Qlikview Excel sheet	C	500	QV Cost
Spotfire	D	200	Sp
Splunk	E	1430	SP12
Mango DB	F	835	MDB

I have to load only two columns Category and Cost.. (Red Text Data)

Thanks in Advance...!!!!

Re: Need Help

Kushal_Chawda — Sat, 02 Jan 2016 06:15:27 GMT

try this

LOAD F1 as Tools,

Category,

Cost,

F4 as Remark

FROM

[Book1.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Re: Need Help

lironbaram — Sat, 02 Jan 2016 06:22:44 GMT

i attach are a qv model and excel file

the qv script looks like this :

Data:

LOAD F1 AS Tools,

Category,

Cost

FROM

[..\Users\Liron\Desktop\Book2.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Re: Need Help

stevedark — Sat, 02 Jan 2016 07:54:27 GMT

Hi Paul,

As you can see from the two other suggestions, you can list which fields you want to take. As you only want two columns in your data model simply exclude everything other than Category and Cost.

You can also pick fields in the Wizard when building your script. Next to each fieldname is a small X. Simply click this next to the fields you want to leave out.

Hope that helps.

Steve