topic Re: Do not load last row of data in App Development

Do not load last row of data

EvanBarrick — Wed, 26 Dec 2018 18:40:58 GMT

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?

Re: Do not load last row of data

sunny_talwar — Wed, 26 Dec 2018 18:48:17 GMT

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?

Re: Do not load last row of data

EvanBarrick — Wed, 26 Dec 2018 18:51:28 GMT

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

Re: Do not load last row of data

sunny_talwar — Wed, 26 Dec 2018 20:00:15 GMT

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

Re: Do not load last row of data

EvanBarrick — Wed, 26 Dec 2018 20:05:01 GMT

Source / Medium	Campaign	Users	New Users	Sessions	Avg. Session Duration	Pages / Session	Payment (Goal 4 Completions)	Make a payment (Goal 6 Completions)
web	IG	616	491	665	182.84	4.21	1	307
referral	(not set)	62	44	74	97.99	3.15	0	45
ESab / IGSAB23	FeeFree	53	35	60	39.73	1.87	0	16
ESab / IGSAB23	FeeFree1126	40	29	42	45.52	1.93	0	19
ESab / RFM	RG1	13	11	16	9.63	1.38	0	1
ESab / RFM	RG3	12	10	14	73.00	1.21	0	0
ESab / RFM	RG2	10	8	12	0.83	1.08	0	0
SocSab / TW	FeeFree	6	4	7	6.86	1.43	0	1
(direct) / (none)	(not set)	3	3	3	299.67	1.67	0	0
		815	635	893	151.48	3.69	1	389

Re: Do not load last row of data

EvanBarrick — Wed, 26 Dec 2018 20:06:36 GMT

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

Re: Do not load last row of data

sunny_talwar — Thu, 27 Dec 2018 11:58:06 GMT

Just do something like this

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

Re: Do not load last row of data

kamikhan — Tue, 11 Feb 2020 19:56:38 GMT

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