topic Load Statement without using File Wizard.. in QlikView

Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:00:12 GMT

Hi All,

I am new to the QV,

I have data in Excel Sheet;

I want to load statement when I am directly copy paste data from Excel Sheet,

I don’t want using FILE WIZARD, could you please help me.

For Ex,

WeekNum	Month	Sales
1	Jan	75
2	Jan	85
3	Jan	60
4	Jan	100
1	Feb	120
2	Feb	100

Like…

Regards,

Senthil.

Re: Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:06:40 GMT

You mean, when you copy paste the data in script editor it should automatically prepare load statement ?

you are looking for something like below

eg :

ExcelData:

Load WeekNum, Month, Sales

From

Data.Excel

Re: Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:22:06 GMT

Hi KS,

Yes,

I am looking like,

Load

WeekNum,

Month,

Sales FROM
[auto number.xlsx]
(ooxml, embedded labels, table is Sheet1);

Regards,

Senthil..

Re: Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:24:15 GMT

As per my understanding, Qlikview will not prepare the Load statement when you copy/paste. May I know the reason why you want do like this?

Re: Load Statement without using File Wizard..

er_mohit — Tue, 26 Feb 2013 05:31:21 GMT

By Using inline function you get it...

go to script menu

in insert tab---->load statement---->load inline--->there you paste your excel data and then ok..

wirte you field name replace F1 like

on double click F1 change it to WeekName as corresponding for all field name....

hope it helps you

Re: Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:46:37 GMT

Hi,

Try something like this.

LOAD * INLINE [

WeekNum, Month, Sales

1, Jan, 75

2, Jan, 85

3, Jan, 60

4, Jan, 100

1, Feb, 120

2, Feb, 100

];

Thanks

Re: Load Statement without using File Wizard..

Tue, 26 Feb 2013 05:49:15 GMT

Hi Mohit and KS,

Thanks for u'r time...

I have huge data and when i am using FILE WIZARD it will take more time.

And I am trying (Inline data Wizard) in insert tab---->load statement---->load inline--->

But, dimension name is missing.

WeekNum

Month

Sales

Regards,

Senthil..

Re: Load Statement without using File Wizard..

sujeetsingh — Tue, 26 Feb 2013 05:56:20 GMT

Seems not as possible but yes u can go to insert option on script window and then inline,

and now copy and pasete