Hello
i have a workbook containing multiple sheets.
there are total 10 sheets.. i want to merge sheets 4 sheets sepertely i a new sheet and 4 more sheet seperately and keeping the other two as it is.
is it possible if i assign a same color or some same criteria or something ?
Solved! Go to Solution.
Hi @cjain
Alteryx doesn't read any formatting information from the excel file, so the colour idea won't work, though it's a good one. You'll have to do something with the sheet names, since that's the only way to tell where the data came from. If the grouping is static, you can include a text input with the sheet names and which group they belong to. Join this to your data to determine the group for each sheet.
If it's dynamic, with either the sheet names or groupings varying, you'll need some way to enter this dynamically. You can use a separate excel sheet in the input file as a key with sheet names/grouping info and join this to main data set. If the user can tell which sheets should be grouped, you can also try to create an analytic app, where an input tool reads the sheet names and cross tabs the list to get the sheet names as headers. Feed this list to two separate List boxes, one for the 1st grouping and another for the 2nd grouping and have the user select the sheet names to group.
Dan
Danilang thanks for the solution.. i have static sheet name .. can you please share with me sample model on how to merge them ..
Hi @cjain
How do you want to merge them? Simply union all the records or do you need to join records? Can you provide a small sample file with 4 sheets, just a few records per sheet and what the result should look like?
Dan
Hi @cjain
Since your sheet names are static, the easiest way to do this is to simply use one input per sheet and union the results
The final formula just gets the sheet name from the full path, if you need it
Here's the output of the first group. The second one is similar
Dan