Daily Update of Image

[KamenRider]

Hi,

Is there a way for Alteryx to update the image (png format) daily using date in the filename? I have this image with filename format "Date.png" (example 10.01.24.png). It updates daily and I would like to update with Alteryx once I run it. I'm trying to use the image tool or the report tool but don't know how to do it. Maybe guys you have ideas on how to do it.

Looking forward for any sharing and assistance.

Kamen

[OTrieger]

@KamenRider 
Potentially it should be possible as the Render tool capable generating PNG format files.

[alexnajm]

What happens when you put a directory tool before your Image tool? Can you get the list, sort & sample to get it down to the one image you need, and then use that file path in the Image tool?

[Matt_D]

 @KamenRider  I think @OTrieger's answer is your best bet. You'll need to mess with text size, render size, margins, etc. but general concept attached.

[alexnajm]

Ah I misunderstood - I read this is you are trying to read in an image file and the file name changes every day. If you could clarify @KamenRider that'd be great

[OTrieger]

@Matt_D 
I guess I would not use Alteryx for this purpose, however it is possible.

Alteryx is a very powerful tool, you can do with it many things, even if Alteryx is not the best choice to do the job, it is still possible. I wouldn't use it for this.

[KamenRider]

HI @alexnajm , @OTrieger @Matt_D 

Yes you are correct, I need Alteryx to locate the latest date using directory. The date is attached to the filename of an image. I need the image to be post as screenshot in the email everyday. Therefore, image will replace everyday based on the date.

An example of results should look like this.

 

Please let me know if you any questions.

Kamen

[alexnajm]

Fantastic - then go ahead and try out the Directory --> Image tool! Worked well in my tests (screenshot below).

If you want to filter the list down based on a time stamp / file name, you can use a Sort on that field & Sample 1st 1 Rows between the Directory and the Image tools to get it down to the record you need. Or maybe just a filter will do!

[KamenRider]

HI @alexnajm 

The filename of the image is with date. example:

09.27.24.jpg.png

09.30.24.jpg.png

10.01.24.jpg.png

Can you please elaborate how can Alteryx be able to change the image to the most current date? This is being run everyday and everyday there are changes on the results of the image. Today, I should be seeing the 10/03 image.

As I can see in your screenshot, this is stuck to only 1 image.

 

Please advise.

Kamen

[alexnajm]

The Image tool is using the file paths from the Directory tool and the "Modify filename for each record" is taking the file paths and reading them in one by one. You can put in any image into the filename part, and it would still read from the list instead

If you want to limit the list to only the one you want to read in, you would limit the list in some way before the Image (in this case, a Sort & Sample will do it) to get it down to the record you want to read in!

I am sure you can get it from here :)