Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
I got Total as extra field in 3 excel sheets, while doing aggregation functions I am not getting correct results ,because of Total as a field .How to avoid it .Plz help.
Thank you.
Use a where clause:
MyData
LOAD * from MyXLFiles*.xlsx (ooxml, embedded labels, table is Sheet1)
WHERE category <> 'Total'
;
Rename the field so every sheet total gets a unique field name.
Hi,
In expression you can use it like
[Total] or "Total"
Better you rename it.
Regards
Anand
Hi Gysbert,
FYI , I have data like this
category dt cr varience tax amount
hm1 20 10 50% .6% 100
hm2 30 10 45% .6 % 120
hm3 40 20 50% .6% 130
Total 350
Sorry I mentioned Total as field in my question , actually it is not. can you help me to take that 'Total' row out .
Thank you.
Use a where clause:
MyData
LOAD * from MyXLFiles*.xlsx (ooxml, embedded labels, table is Sheet1)
WHERE category <> 'Total'
;
Hi Anand,
Can you say in detail..
Hi Gysbert,
Do i Need to use , Where Not Exist function here....
No.