'Total' field

[#1]

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.

[Gysbert_Wassenaar]

Rename the field so every sheet total gets a unique field name.

[its_anandrjs]

Hi,

In expression you can use it like

[Total]  or  "Total"

Better you rename it.

Regards

Anand

[#4]

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.

[Gysbert_Wassenaar · Accepted solution]

Use a where clause:

MyData

LOAD * from MyXLFiles*.xlsx (ooxml, embedded labels, table is Sheet1)

WHERE category <> 'Total'

;

[#6]

Hi Anand,

Can you say in detail..

[#7]

Hi Gysbert,

Do i Need to use , Where Not Exist function here....

[Gysbert_Wassenaar]

No.