Hello,
I have a dataset that I would like to be able to dynamically filter based on values in a Google Sheet. This feels like a fairly simple MagicETL to me but I'm stumped at the moment.
In short, the PROD dataset is good to go and I would ideally be filtering one column from the PROD set based on values in one column in a GoogleSheet.
For example:
PROD
Site A. 5,000 sales
Site B 10,000 sales
Site C 15,000 sales
Google Sheet
Site A 10,000 sales
Site C 15,000 sales
The outcome I'm hoping for:
PROD v2
Site A 5,000 sales
Site C 15,000 sales
Seems the Filter tile is the way to go but I'm thrown by the "Enter Value to Compare" field.
Thank you,
Joe