Filtering Fact Data in data loader

Ethel — Thu, 03 Feb 2022 18:44:19 GMT

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!!

Re: Filtering Fact Data in data loader

chris_djih — Fri, 04 Feb 2022 08:12:05 GMT

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?

topic Filtering Fact Data in data loader in App Development

Filtering Fact Data in data loader

Re: Filtering Fact Data in data loader