Error in Find and Replace Tool -

Hello Reader,

While opening my designer file, I see issue with Find & Replace Tool every time I open it.

Can you please help? I have attached screenshot for reference.

Each time I have to reconfigure and save it. Yet the same issue.

Please note, I recently changed my laptop and installed alteryx on it. I am facing this issue since then. Is there any connection?

Issue - Find and Replace2.PNG

Issue - Find and Replace1.PNG

Error Message

Join

Accepted answers

All comments

Qiu

@ankush-agrawal
Do you mean you have corected configured the Find and Replace tool and saved the flow, and the error in the atached will pop up nex time you opened the flow?

ankush-agrawal

Yes, you are right.

grazitti_sapna

@ankush-agrawal, just to clarify are you using some kind of connector where you have to run it every time to get the field names? Suppose you use a connector then when you add a select tool you have to run the workflow in order to view the field names?

Thanks!

Qiu

@grazitti_sapna
Good point.
I would suspect the same.

ankush-agrawal

I am attaching the snapshot of workflow here. To answer your question, does dynamic input tool counts?

Snapshot 3.PNG

grazitti_sapna

@ankush-agrawal, do the columns change when you are using the dynamic input tool I mean the schema of the files?

ankush-agrawal

Do you mean adding select tool, and changing columns up and down? Can you suggest some example?

grazitti_sapna

@ankush-agrawal, the dynamic tool you are using might be the case as it is not static. I tried to replicate this and was successful.

Thanks!

ankush-agrawal

I am using similar setup for another Find and Replace in same designer. Don't see any issue there. Why in this case?

What is the solution?

image.png

grazitti_sapna

@ankush-agrawal, in the screenshot for the first part of the workflow you are using a static file with the columns to be replaced but for the second workflow you are using a dynamic tool to replace the or append the field which you are calling using dynamic input tool try passing a static table there and the issue will be resolved.

Thanks!

ankush-agrawal

I understand your point. But I think I found the solution, it was error from my end. In the dynamic input tool, I had incorrect file as sample, which was creating the issue. When I referred to correct file, I can see the issue is resolved, I am not getting any error when I reopen the file.

Appreciate your time and sharing the understanding.

grazitti_sapna

@ankush-agrawal , yes that is one of the cases as well as you put a file in the dynamic input tool it will read the columns on that basis, if you just have a specific file then you can use that to input default columns.

Glad we could help!

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703