topic Re: Alteryx workflows source and target table details in Alteryx Server Discussions

Alteryx workflows source and target table details

lagisettya — Tue, 28 Apr 2020 12:12:58 GMT

We have 120 workflows and want to find out source and target tables of all the workflows. Can you please guide us how to extract workflows source and target tables details.

Re: Alteryx workflows source and target table details

DavidP — Tue, 28 Apr 2020 15:07:38 GMT

I assume you're looking to identify the database tables the workflows are reading from and writing to?

You can do this by loading the alteryx workflow file as a txt file with \0 delimiter and parse it with xml parse tools or an xml parse macro. You can then look what to search for in the results to find the configuration of the input and output data tools.

You should read the yxmd file as a delimited text file with \0 as delimiter.

Re: Alteryx workflows source and target table details

danilang — Sun, 03 May 2020 14:36:44 GMT

Hi [at-mention author],

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!

Dan

Re: Alteryx workflows source and target table details

fmcrashid — Thu, 18 Nov 2021 15:23:53 GMT

Opened wf with \0 is okay but getting error when parse xml. Any suggestions?

Re: Alteryx workflows source and target table details

DavidP — Wed, 22 Dec 2021 10:05:23 GMT

Hi @fmcrashid,

Sorry for only getting back to this now.

To get around it, I skipped the first row and then checked the setting in the XML Parse tool to ignore XML errors

Re: Alteryx workflows source and target table details

DavidP — Wed, 22 Dec 2021 10:10:13 GMT

One other thing you might want to look at is the Parse XML macro in the public Alteryx Gallery.

https://gallery.alteryx.com/#!app/Parse-XML/584b5589f499c704689e363b