Power Pivot / Excel Office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1857507%22%20slang%3D%22de-DE%22%3EPower%20Pivot%20%2F%20Excel%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1857507%22%20slang%3D%22de-DE%22%3E%3CP%3EI'm%20trying%20to%20create%20an%20analysis%20file.I%20get%20daily%20reports%20for%20different%20locations%20in%20CSV%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20in%20these%20automatically%20created%20reports%2C%20the%20first%20row%20does%20not%20belong%20to%20the%20required%20table%20(in%20cell%20A1%20there%20is%20always%20%23Type%20system.Data.DataRow)%20-%20when%20I%20read%20the%20database%2C%20I%20can%20somehow%20set%20that%20this%20line%20ignores%20each%20file%20and%20the%202.%20line%20can%20be%20used%20as%20headings%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20set%20the%20file%20combination%2C%20I%20don't%20get%20it.%20Later%20in%20the%20query%2C%20if%20I%20edit%20the%20sample%20file%20accordingly%2C%20it%20does%20not%20apply%20the%20settings%20to%20all%20other%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20it%20for%20a%20week%20now.%20Please%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20greetings%3C%2FP%3E%3CP%3EAnja%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22A_Donner_0-1604591517817.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231704iDDCA74E0A03A8C25%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22A_Donner_0-1604591517817.png%22%20alt%3D%22A_Donner_0-1604591517817.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1857507%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1857841%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20%2F%20Excel%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1857841%22%20slang%3D%22en-US%22%3ECan%20you%20perhaps%20post%20two%20dummy%20CSV%20files%20(with%20non-sensitive%20data)%3F%20We%20only%20need%20-say-%20two%20lines%20of%20actual%20data.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Ich versuche eine Analyse Datei zu erstellen. Ich bekomme dafür tägliche Reports für verschiedene Standorte im CSV Format.

 

Mein Problem ist, dass in diesen automatisch erstellten Reports die erste Zeile nicht zu der benötigten Tabelle gehört (in der Zelle A1 steht immer #Type System.Data.DataRow) - kann ich beim Einlesen der Datenbank irgendwie einstellen, dass diese Zeile bei jeder Datei ignoriert und die 2. Zeile als Überschriften verwendet werden kann?

 

Bei der Einstellung der Dateikombination krieg ich das nicht hin. Wenn ich später in der Abfrage die Exempeldatei entsprechend bearbeite, übernimmt es die Einstellungen nicht auf alle anderen Dateien.

 

Versuche es nun schon seit einer Woche. Bitte Hilfe

 

Danke und liebe Grüße

Anja

 

A_Donner_0-1604591517817.png

 

 

1 Reply
Highlighted
Can you perhaps post two dummy CSV files (with non-sensitive data)? We only need -say- two lines of actual data.