Hi @Prakash_Kumar
There's a couple things to note to achieve (what I assume) you're trying to do:
- Excel hyperlinks/file paths in general do not support a sheet reference. In other words, you can specify an Excel file in Window Explorer and it will open, but if you add a sheet reference, it will not. This means that unique hyperlinks for each country/sheet are not possible (afaik). In the example, the file path I use for the hyperlinks all go to the same file, and open the first sheet (default) every time.
- It's important to write the file output path once and then append that field to anywhere you'd like to use it. This will ensure that every reference points to the same file.
Check out the attached workflow to see the solution I built in action.
