Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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?