Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi KS,
Yes,
I am looking like,
Load
WeekNum,
Month,
Sales FROM
[auto number.xlsx]
(ooxml, embedded labels, table is Sheet1);
Regards,
Senthil..
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?
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
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
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..
Seems not as possible but yes u can go to insert option on script window and then inline,
and now copy and pasete