Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-06-16 03:32 PM

Data Load

i want to load data given in attached excel.

into qvd but i want to skip total row given after each group.

how it will be done?

Preview file
9 KB
389 Views
0 Likes
1 Solution

Accepted Solutions
barryharmsen
Partner - Creator II
Partner - Creator II
‎2012-06-16 05:01 PM

Use the table wizard and add "WHERE NOT IsNull(Group);" after the generated LOAD statement.

View solution in original post

277 Views
0 Likes
1 Reply
barryharmsen
Partner - Creator II
Partner - Creator II
‎2012-06-16 05:01 PM

Use the table wizard and add "WHERE NOT IsNull(Group);" after the generated LOAD statement.

278 Views
0 Likes