This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
try with a fixed lenght load
[@1:100] as field
(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
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.
LOAD [@1:100] as field
LOAD field as TranId RESIDENT Raw Where recno() = 1;
JOIN(Trans) LOAD field as Customer RESIDENT Raw Where recno()=2;
Indeed, one transaction per file, i'll try this!