File browser not working as expected, still defaulting to my local path

Hi All,

I am working on a WF where I am using a file browser and in the action I am selecting the Update value option since I am specifying the range with in the input file. But when I run the same package on the different machine, it is still defaulting to the path which was specified on the input file rather than the path which I am providing from the File browser interface.

Here is the screenshot of the action I am specifying, let me know if I am missing anything here?

Thanks in Advance!

Interface Tools

Accepted answers

patrick_digan

@aparanjith1 Make sure your action tools with the update formulas all have the file-value line selected, and then we'll need to change your formulas to something like this (obviously each one would have its own range)

Replace([#1],"$`","$A6:U7`")

When I used the interface designer (view >>> interface designer) and then the test view (second option of the 4), you can see that the file browse tools is passing the file and sheet name like this:

DummyData - Copy.xlsx|||`Sheet1$`

Ultimately, we want something like this in our input tool to grab range A6:U7

DummyData - Copy.xlsx|||`Sheet1$A6:U7`   >>>>> Filename.xlsx|||`Sheet Name$Range_Start:Range_End`

You can see the range comes between the $ and ` at very end. Thus we can use the replace function specified above to do that. The attached seemed to be working on my end.

Instead of reading the same file in several times to get the different excel ranges, you could read the entire sheet and then use a select records tool to grab just the rows of data that you want. You may have to change your input tool to check the box about first row contains data and then use select tools or dynamic rename tools to get the right field headers, but that may be better than reading in the same file so many times. Just a thought!

New Workflowtest1e.yxwz

All comments

patrick_digan

@aparanjith1 In your action tool, you will need to click on the third line that starts with "File-Value=". Let me know if there are still issues after that!

aparanjith1

Thanks for the reply Patrick, but since we have the range specified for the inputs we switched to using Update value with formula, but somehow it is still getting failed. Below is the screenshot of the formula we are using; can let me know if am I missing anything here? I am also attaching the package file for your reference.

New Workflowtest1e.yxwz

aparanjith1

I am still stuck at this step, since I am using File browser for the Excel range input, I am unable to make the file browser to select the range which is specified in the formula. Can someone please help me in this?

Thanks in advance!

patrick_digan

Replace([#1],"$`","$A6:U7`")

When I used the interface designer (view >>> interface designer) and then the test view (second option of the 4), you can see that the file browse tools is passing the file and sheet name like this:

DummyData - Copy.xlsx|||`Sheet1$`

Ultimately, we want something like this in our input tool to grab range A6:U7

DummyData - Copy.xlsx|||`Sheet1$A6:U7`   >>>>> Filename.xlsx|||`Sheet Name$Range_Start:Range_End`

You can see the range comes between the $ and ` at very end. Thus we can use the replace function specified above to do that. The attached seemed to be working on my end.

New Workflowtest1e.yxwz

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335