Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Howdy!
Can someone please assist with the load of my log files?
The problem is, is that qlikview is removing the blank rows. Which causes problems because the log files are all the same, but they won't always have every row filled in.
every time i load the log files it removes the blank rows...how can i keep them?
Also...they need to be transposed or turned to the right so i can concatenate all log files into a transnational table.
Much thanks!
-David
try with a fixed lenght load
LOAD
[@1:100] as field
FROM
Log_File_Blankrecords.txt
(fix, codepage is 1252);
I was trying that...but I couldn't figure out how to do that AND transpose them to get a transactional database...any ideas?
I'm not understanding how you want yo transpose the data. Can you give an example?
Each log file is vertical, and i want to make a transactional database.
The trouble is, without the fixed width load manner, i lose the spaces in the log files. That mis-aligns the data.
If i used fixed width, i cannot transpose the files to create a transactional database.
please post your expected result
regards
Marco
So you mean you can't use the builtin transpose function. Is there one transaction per file? You could use the record # to load each record into a field.
Raw:
LOAD [@1:100] as field
FROMLog_File_Blankrecords.txt
(fix, codepage is 1252);
Trans:
LOAD field as TranId RESIDENT Raw Where recno() = 1;
JOIN(Trans) LOAD field as Customer RESIDENT Raw Where recno()=2;
etc.
-Rob
Indeed, one transaction per file, i'll try this!