Challenge #387: LEGO® My Data (Part 2)

[PhilipMannering]

Solution attached...

Spoiler

@patrick_digan Can you use '%Question.List%' in the Filter Tool → [Year] IN ('%Question.List%') ? I could not get this to work.

[patrick_digan]

@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:

[PhilipMannering]

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

[Yoshiro_Fujimori]

As my workspace cannot use Download Tool, I can only follow up to Step 3.

I will do the rest from my home pc.

Spoiler

Workflow

App screen
App Results

[hdesai7]

One of the toughest I have had the pleasure of working through!

Spoiler

 

Spoiler

 

[tammybrown_tds]

Macro practice is a wonderful thing.

Spoiler

[alacoume]

This one is really hard!

[AkimasaKajitani]

I made the new workflow using Python tool for resolving the Blob error.

Spoiler

I use the Python package "Pillow" for this solution.


I think when the blob error occures, the jpeg file with some trouble is downloaded. But other Windows application can load those jpeg files. So I load them by using Python package "Pillow" and then save as "Correct" jpeg files using Pillow again. After that, I load those "Correct "jpeg files with no error by Image tool. But if we use the Python tool in Batch macro, the workflow is very slow, so I don't use the Batch macro for this solution.

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)

 

[Sebastian_Chaieb2]

Nice! I love it 😍

Thanks for this @AkimasaKajitani 

I have to increase my Python skills 💪

[networkmike42]

This was a lot of fun.  A lot of work, but a lot of fun.

Here is the workflow:

Spoiler

 

Here is the Macro

Spoiler