Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached...
@patrick_digan Can you use '%Question.List%' in the Filter Tool → [Year] IN ('%Question.List%') ? I could not get this to work.
@PhilipMannering You sure can! You would either need to change your filter tool or your listbox. The listbox has the ability to specify the string that is sent over, so you just have to make sure the quotes match.
Change filter:
Since the listbox already has the quotes, you don't need any quotes in the Filter tool.
Change listbox:
If your filter already has the beginning and end quotes like you mentioned [Year] IN ('%Question.Year%'), then the listbox no longer needs beginning and end quotes (just the separators). You can then test something like 2014/2015:
@patrick_digan. Ah, it's the fact that it %Question.Year% gets replaced without the quotes that was the bit I was missing. Perfect. Thank you!
As my workspace cannot use Download Tool, I can only follow up to Step 3.
I will do the rest from my home pc.
App Results
I made the new workflow using Python tool for resolving the Blob error.
from ayx import Package
Package.installPackages(['Pillow'])
from ayx import Alteryx
from PIL import Image
df = Alteryx.read("#1")
image_list =[]
print(df['DownloadTempFile'])
for img in df['DownloadTempFile']:
if img is not None:
with open(img, mode='rb') as f:
image_file = Image.open(img)
image_file.save(img+'.jpg', quality=95)
image_list.append(img+'.jpg')
else:
image_list.append(None)
df['image_path'] = image_list
Alteryx.write(df,1)