Hello Experts,
I have a requirement in which in the Output File I want Global Identity column name to have the ID by which the sheet is getting generated.
Thanks in advance
@ferha_jafri - you could accomplish this by replacing the string "Global Identity" with the ID# in the table XML.
If you look at the table field using a Browse tool, you can see that the field contains the code used to construct the table:
We can use a formula tool to look for the words "Global Identity" in that text and replace it with the ID # for each row.
Note that once we replace the table text, we need to convert the table back into a report object with a Text tool, and then change the Layout tool to use the new Text field.
And then the output will have the ID# as the column header:
Hi @ferha_jafri
You can select the ID field with the Basic Table tool to include the ID as another field in the output.
No that is not the requirement, Global Identity should get replace with ID.
I've had another look at what I think you require. I added a small batch macro to create reports for each ID and to change the field name of each report. Please see if this fits more to what you need.
I am new to Alteryx so not sure how to incorporate Macro in my workflow.
