I have one input file. I want to slice and dice the data from the input file to create an output file with two tabs as shown below:
(a) The first column in the output file should be an incremental number like 1, 2, 3, etc.
(b) The top row of the output file should have a fill color of yellow and a font color of blue.
(c) Freeze the top row of both tabs in the output file.
Looking for your advice and suggestions.
Input File
Code | Name | Type |
FR123 | Apple | Fruit |
VG1956 | Carrot | Vegetables |
VG203 | Onion | Vegetables |
FR456 | Grapes | Fruit |
One Output File with two Tabs
Tab-1 - Fruit
# | Code | Name | Type |
1 | FR123 | Apple | Fruit |
2 | FR456 | Grapes | Fruit |
Tab 2 - Vegetables
# | Code | Name | Type |
1 | VG1956 | Carrot | Vegetables |
2 | VG203 | Onion | Vegetables |
Really simple to do! Use the Take File/Table Name from Field and pick your Type column.
If my reply help you, please marked as an accepted solution. Thank you!
To format the Excel sheet, you can use a blob template.
https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/
Also reposted here.
(a) The first column in the output file should be an incremental number like 1, 2, 3, etc. - COMPLETED
(b) The top row of the output file should have a fill color of yellow and a font color of blue. - PENDING
(c) Freeze the top row of both tabs in the output file. - PENDING
@kal-tech
Please find attached
mark done if solved
Regards
Raj
Raj - Yes, the top header row background and font color are working perfectly. Thank you very much. Is there a way to
(a) freeze the top header row
(b) add a filter in both tabs in the spreadsheet?