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
解決済! 解決策の投稿を見る。
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.
Hi @ferha_jafri
Your original workflow is very close to the output your looking for (Dynamic output.xlsx in your original post). Just uncheck the Group Data Into Separate Reports
Dan
Sorry but this is not that is required, I want to generate sheets corresponding to each ID.
I am new to Alteryx so not sure how to incorporate Macro in my workflow.
@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: