Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Just do something like this
LOAD [Source/Medium], Campaign, Users, [New Users], ... FROM .... Where Len(Trim([Source/Medium])) <> 0;
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?
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
Would you be able to share an image or a sample of your data to show what you have?
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 |
The last row of data is default from the data source. They are totals
Just do something like this
LOAD [Source/Medium], Campaign, Users, [New Users], ... FROM .... Where Len(Trim([Source/Medium])) <> 0;
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 ..