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: 
EvanBarrick
Creator
Creator

Do not load last row of data

My the last row of my data file is a totals row (working to get this excluded from the source) However in the interim, can I alter my script so that this row is excluded?

1 Solution

Accepted Solutions
sunny_talwar

Just do something like this

LOAD [Source/Medium],
  Campaign,
  Users,
  [New Users],
  ...
FROM ....
Where Len(Trim([Source/Medium])) <> 0;

 

View solution in original post

7 Replies
sunny_talwar

Is there something unique about this row? Like does it say total in one of the column or is there a column which always have a value except for the total row?

EvanBarrick
Creator
Creator
Author

It is always the last row of the data. There are no labels that say total in any of the columns, just that the last row contains the sum of the columns that contain numerical data

sunny_talwar

Would you be able to share an image or a sample of your data to show what you have?

EvanBarrick
Creator
Creator
Author

Source / MediumCampaignUsersNew UsersSessionsAvg. Session DurationPages / SessionPayment (Goal 4 Completions)Make a payment (Goal 6 Completions)
 webIG616491665182.844.211307
referral(not set)62447497.993.15045
ESab / IGSAB23FeeFree53356039.731.87016
ESab / IGSAB23FeeFree112640294245.521.93019
ESab / RFMRG11311169.631.3801
ESab / RFMRG312101473.001.2100
ESab / RFMRG2108120.831.0800
SocSab / TWFeeFree6476.861.4301
(direct) / (none)(not set)333299.671.6700
  815635893151.483.691389
EvanBarrick
Creator
Creator
Author

The last row of data is default from the data source. They are totals

sunny_talwar

Just do something like this

LOAD [Source/Medium],
  Campaign,
  Users,
  [New Users],
  ...
FROM ....
Where Len(Trim([Source/Medium])) <> 0;

 

kamikhan
Contributor III
Contributor III

hi 
How are you. 
i have one issue if you want to help me. i have a data since 2017 to so on. now i have load data every month end. when i click reload data data will be load 2017 to 2020. but i want to load only 2020 jan. instead of 2017 ..