Relevance substitution in analysis

I am trying to create an analysis to read the filesize of a db file.
But the file is located in a folder which contains the hostname.

How do I create a string with the hostname in it and then use this in an analysis?

size of file "C:\DBFolder%hostname%\file.db

Here are 3 examples you might consider:

size of file ("C:\DBFolder" & hostname & “\file.db”)

size of file “file.db” of folder ("C:\DBFolder" & hostname)

size of file “file.db” of folder (hostname) of folder “C:\DBFolder”

1 Like

This is how I would typically handle it:

sizes of files "file.db" of folders of folders "C:\DBFolder"

You could also add a filter to the folders to limit it to one with the hostname if needed.