Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Statement without using File Wizard..

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.

7 Replies
Not applicable
Author

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

or

you are looking for something like below

eg :

ExcelData:

Load WeekNum, Month, Sales

From

Data.Excel

Not applicable
Author

Hi KS,


Yes,

I am looking like,

Load 

WeekNum,

Month,

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

Regards,

Senthil..

Not applicable
Author

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?

er_mohit
Master II
Master II

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

Not applicable
Author

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

Not applicable
Author

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

sujeetsingh
Master III
Master III

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

and now copy and pasete