Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Ethel
Creator III
Creator III

filtering data before uploading

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 simply write where clause(where location='A'). I have to use this condition in my set analysis formulas, 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!!

 

 

 

Labels (3)
1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

1 Reply
albertovarela
Partner - Specialist
Partner - Specialist

2022-02-03_16-41-45.png