Filtering Fact Data in data loader

[Ethel]

Hello, could you please help me to filter data in data loader.

I have "Fact" table

VendorId

LocationId

Total.

I have table "Location" with dimensions

LocationID

Location

LocationType.

If Location type is A, I have to upload this data.

I cannot  write where clause(where location='A'). I have to use this condition in my set analysis formulas(Otherwise it's not working), but I have more than 20 reports. Is there a way, I can add this condition in data loader. I think there should be something with peek, but I'm not sure...

Thanks a lot in advance!!

[Ethel]

Hello, could you please help me to filter data in data loader.

I have "Fact" table

VendorId

LocationId

Total.

I have table "Location" with dimensions

LocationID

Location

LocationType.

If Location type is A, I have to upload this data.

I cannot  write where clause(where location='A'). I have to use this condition in my set analysis formulas(Otherwise it's not working), but I have more than 20 reports. Is there a way, I can add this condition in data loader. I think there should be something with peek, but I'm not sure...

Thanks a lot in advance!!

[chris_djih]

Hi @Ethel , i am a litel bit confused: you say you cannot use where clause.. why?
Then you sy something about set-anaylsis and then you switch back to data loader (which i suppose means script editor?). What do you mena with reports? and what distinguishes these reports.
can you please provide more background information and a clearer vision of the goal? can you may provide screenshots of the desired outcome in an excel table?