How to link data from excel

[abc_18]

Hi,

I need to exclude some 'order number' in my dashboard report because they are causing duplicate records.

I am trying to store those order number in excel , so later if I want to remove from report I can easily delete from excel.

As app is in production, so can't change every time in Prod.

How can I achieve this, please suggest.

Thanks

[saimahasan]

How frequent those order numbers will change(added/subtracted) in your data??

[bramkn]

Load the Excel file with the field named something different than the fields already in use. Than load with a where not exists on that field.

[abc_18]

Hi Saima,

Not Frequently, may be in a month

[saimahasan]

So for that you can make monthly change in excel if you don't have any other tagging in your data to find the exclusion orders.

[abc_18]

We don't want to do any change in excel monthly wise.

Is there any solution that,we can exclude those order numbers in report?

[abc_18]

Hi Bram,

I tried this, but still getting those records.
     

Excel:

LOAD

    "Duplicate order"

FROM [lib://2.External_data/Backorder.xlsx](ooxml, embedded labels, table is Sheet1)

Where not Exists ([Duplicate order]);

[saimahasan]

Is there any indicator in your data basis which you identify those orders??

[bramkn]

Hi the load with the where not exists statement should go at the normal order table. so where you want to delete those records.

[abc_18]

HI Bram,

Can you please explain, then what's the need to maintain those records in separate excel