Retrieve Table name from a TWB file

Hello Alteryx Experts,

Please note I am new to Alteryx and am looking for help to read Metadata from TWB file.The issue that I am facing is I am not able to get table for a column which is available in datasources tag of the TWB XML file. If anybody could point me in the right direction would really be great.

Thanks in advance.

Best Regards,

Vishant

Tableau

Accepted answers

All comments

grazitti_sapna

Hi @vishantshenoy , can you please provide a sample file to investigate?

Thanks.

vishantshenoy

grazitti_sapna

Please note I am unable to upload the TWB file proprietary data or files cannot be uploaded.

To give you more information about the issue, the Tableau Workbook from which I am trying to get Metadata is connected to Ms SQL Server DB. The data source has two tables joined with common fields in Where clause.

When I run the attached workflow it gets the most of the info like column name, datatypes, calculated field names and calculation string, except for the table name which appears null.

But if include only one Table in the Tableau datasource and execute the workflow, the table name field is populated without any issue.

So it looks like is data source has two or more tables, the workflow is unable to get table name. But with one table it works perfect.

Let me know please if you need any other information.

Thanks,

Vishant

Thanks.

Sample_Workflow.yxmd

grazitti_sapna

Hi @vishantshenoy, I have downgraded the version of the file but keep this file and the input file at same location or if you change the inputfile then use this config.

Thanks.

Twb-parse-GS.yxmd

vishantshenoy

Hi @grazitti_sapna

Not sure if I am I doing something wrong, the packaged workflow and TWB file are in same folder "C:\Vishant\Tableau Audit Tool\TEMP"

But I get an error :- The field "worksheet_outer_WML" is not contained in the record. Please let me know if something has been missed out:-

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335