Passing Directory field from Directory tool to macro

So hopefully this is a really simple one, thanks in advance! So i've pulled the directory for a given share drive which is \\smb.waunas21f..... etc. Now it is then being passed to a macro where it is going to update a formula. But it gives the error attached:

Capture2.JPG

Capture3.JPG

Capture1.JPG

Macros

Accepted answers

All comments

gabrielvilella

I'm sorry, but it is not possible to determine what is wrong based on the information provided. We need to see the data that is going into the macro, what is the tool that is being updated within the macro, how it is being updated, and what operation is being performed with that data within the macro. What it looks like is that you are trying to get the date from the file name and do something with it, and the format or type of the data does not match what you are trying to do.

tkong

looks like my company blocked the screenshots. I am passing the directory field from the directory tool. it goes into a macro where it updates the assigned formula. what that formula is doing is creating a new field called "keydir" and basically filling down the records with the value in quotes "\\smb.waunas21f....." with the new row of data being passed to it. In the macro, it is using action tool and control tool on the formula, replacing the text in the formula to the new directory value. It is a V_WString

gabrielvilella

The issue is probably on the formula, the value that is coming from the control parameter is not what the expression is expecting to receive. Maybe the data type. I would only be able to fix this by seeing the actual data.

tkong

Here's the files, thanks again

Main.yxmd

Apply Keydir.yxmc

tkong

the error is Apply Keydir (28) Record#1: Tool#6: Parse Error at char(0): Parse Error (Expression #1) and it continues through all the records. the confusing thing is that the workflow passes "Directory" field from directory tool and character "0" is "\" from the string \\smb.waunas21f.hcsc... etc.

wdavis

Hi @tkong

It is a bit trickier to troubleshoot without the data. One option to test would be changing your double quotations to single quotations in the expression of the formula that sits in the batch macro for the "KeyDir"

Thanks

Will

tkong

@wdavis - tried to change the quotations to single quotations but that did not work, i edited the formula tool quotations and action tool quotations.

How can I include the data? I am trying to use the export function but that is not keeping the data. Putting a output file tool after the select (20) tool generated the file attached.

Directory tool.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703