List of sheet names - not showing all sheets`?

[Hamder83]

Hi 

Im trying to import a bounch of xlsx files.

im using the Input data tool.

When I do - i get the Sheets: SummeringsRapport and Fakturaspecification for all files.

But I have one file with a 3. sheet called ....More Data

If I do a input Data on that specific file with 3 sheets i get all 3. sheets? 

[RolandSchubert]

Hi @Hamder83 ,

if you use Input Data tool and select "Import only list of sheet names", you'll get a list of all 3 sheets, it should work idenpendend of the number of sheets

Best,

Roland

[Hamder83]

Hi Roland 

For some reason it does not show all sheets:

Because its what im doing. It shows two sheets pr. file.

But if I do a Inpurt Data - List of sheet names for the one file with 3. sheets it works?

[wdavis]

Hi @Hamder83 

Do all of your files contain the 3rd tab '3... more data'?

Thanks

Will

[Hamder83]

Hey 

No they dont 😕 

Im having a hard time getting a tool, that can import excel files and sheets - take the header from each sheet - and then combine based on common values. @RolandSchubert  has put a lot of effort into helping me in a earliere thread.

But I cant seem to find a working solution 😕 

[RolandSchubert]

Hi @Hamder83 ,

in fact they don't, if the first workbook has not all sheets ...

I've created a macro, that should solve your problem (hopefully).

Best,

Roland

[Hamder83]

Hi @RolandSchubert 

You must hate me by now, with all the effort you put into helping me,

But i cannt get the macro working - it only loads one file despite what I do?

[RolandSchubert]

Don't worry ... I want to get it solved.

I changed the macro a bit. Please try again.

[Hamder83]

Hey Robert  

That seems to work! 

Can I be a real pain in the **bleep**? Only beacuse im not 100% sure of what the macros are doing.

I found out hat we get some additional data - so we can recieve up to 3 specifications pr. invoice.

Most are handled in the work you have done already. But the last part comes as 2 different specifications for the same shipments.
And i was trying to add these in the macro - by adding " [F1] == 'Sendingsnummer' "

This works alright. But the two files has some common fields (since its regarding the same shipments) but they also have some difficalties. But how do i do a join by name with data comming from the same source? 

Ive attached all 3 specifications regarding 1 invoice as an example

I know the 2 new files need to get their headers changed in the flow to match the original specification. I just need to not have the data double from the new files?

[RolandSchubert]

Hi @Hamder83 ,

just to be sure:

sheets 'Fakturaspecifikation' and '...data fortsat...(3)' on one hand and 'faktura' on the other hand include partially identical data (e.g. columns Vægt, Længde, Bredde, Højde). You want to include both parts, but you want to avoid to include the value, that are in both.

Are the rows in sheet 'faktura' in any way related to the rows in the other sheets? Or is 'faktura' a different representation of the same data? Unfortunately, it's not really clear.

Best,

Roland