Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Field changing from VW_string to V_string on output and messing up my dynamic input

chickenlicken
8 - Asteroid

I've got a dynamic input tool that is pulling multiple sheets from a single Excel file into my workflow

 

The same workflow then creates new sheets in that Excel file

 

This has been working fine, but for some reason for one instance of the workflow it changes one of the fields from a VW_string to a V_string... which breaks the dynamic input.

 

It's not easy to post an example, but does anyone have any ideas about how I could fix this or get to the bottom of why it is changing?

7 REPLIES 7
messi007
15 - Aurora

@chickenlicken,

 

Before the dynamic input you can use a multi-field formula and change the type :

 

1- Select show that the column as a String

 

messi007_1-1642430377042.png

2- Use Multi-Field and change the type

 

messi007_0-1642430303065.png

 

3- The new column type

 

messi007_2-1642430416553.png

 

Attached the workflow.

 

Hope this helps,

Regards,

 

gabrielvilella
13 - Pulsar

Hi @chickenlicken, you probably need to control the field type and size before writing data back to that file. You can do this using a Select tool, forcing a specific field type.

csmith11
11 - Bolide

Replace the Dynamic Input with a Batch Macro Input Tool Instead. (This approach is typically a lot more flexible (Far more robust), and is not as prone to breaking for minor changes.

 

See Macro Attached:

csmith11_1-1642431808757.png

 

 

 

 

 

How to Deploy the Macro: (Let me know if you have additional questions. Or if you haven't deploy a macro before)

 

csmith11_0-1642431643843.png

 

chickenlicken
8 - Asteroid

Thanks all.  @messi007 I tried that but if it is before the dynamic input it seems to just change the list of sheet names I've inputted just before the dynamic input, and @gabrielvilella your suggestion inexplicably doesn't work..

 

@csmith11  I'll try the macro, thanks a lot for your help

csmith11
11 - Bolide

@chickenlicken great! Let me know how it goes and whether you have any questions. If it ends up working out for you, please consider marking as the solution to help other Alteryx Users identify the solutions faster.

messi007
15 - Aurora

@chickenlicken,

 

I don't see why it will change the sheet name. You have to be sure that the multi-field formla look like this :

with copy output fields and add unchecked

messi007_0-1642441370320.png

Could you share a screen shot of the tool ? It will help me to check.

 

Regards,

chickenlicken
8 - Asteroid

@csmith11 That worked, thank you very much.  I had to change the input to multiple files rather than sheets from the same workbook but that is probably more robust anyway.

 

 

@messi007 I removed that part of my workflow now - thanks though, you showed me something I didn't know, so appreciated.

Labels