Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANew learn of importing same type files at once using 'Input Data' Tool. And a new solution to pick up specific cell from excel. Nice try!
here you go..
I first uploaded the files using the wildcard so that each sheet 1 would upload and included FileName. Then used the tile tool with the unique column being filename, which gave me a sequence for each sheet. Then filtered for Tile Sequence Numbers 2 or 8, which gave me the 2nd and 8th row of each sheet i uploaded. After this used two select tools to split the 2nd column and 3rd column, which is what this task calls for. Used a couple sample tools to select the specific record I needed from each and then joined them back based on record position, renaming each column appropriately.