Need Help

[paulwalker]

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...!!!!

[Kushal_Chawda]

try this

LOAD F1 as Tools,

     Category,

     Cost,

     F4 as Remark

FROM

[Book1.xlsx]

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

[lironbaram]

hi

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);

[stevedark]

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