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? 

[Hamder83]

Hi 

'Fakturaspecifikation' and '...data fortsat...(3) is one set of data - the only common with 'faktura' is the invoice number. 

There can be two files with 'faktura' sheets, for the same invoice. In this case its the same 6 shipments in both files, but each file contain different info about the shipment. And both files are not equal in structure tho they have some common fileds like 'Sendingsnummer', weight and so on.

So basicly it needs to do the same for 'faktura' as it does for 'Fakturaspecifikation' and '...data fortsat...(3) - conbine based on common values, and then in the end join all data on common values.

.. Man this is hard to explain, but I hope it makes sense?

[RolandSchubert]

If I completely understood, the difference is the header. I extended the DK Loader, try it and let me know, if it solves the remaining problem. 

[Hamder83]

Hey (again) 

It loads 'faktura' perfectly - but it doesnt add 'Fakturanummer' or 'kundenummer' 

and ive been fiddleling with the macro for hours now, but im not completely sure of what im doing. So I cant figure how to fix it 😕 

[RolandSchubert · Accepted solution]

Hi,

a bit tricky ... join field (file) was not selected. In addition, I modified the Join field a bit. Looks better now.

Best,

Roland

[Hamder83]

That worked, thank you SO much for your effort! 

You just saved me for like a weeks work every month 😄