Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
dcohen13
Contributor III
Contributor III

Log File Load - Need to Keep Blank Records

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

7 Replies
maxgro
MVP
MVP

try with a fixed lenght load

LOAD

  [@1:100] as field

FROM

Log_File_Blankrecords.txt

(fix, codepage is 1252);

1.png

dcohen13
Contributor III
Contributor III
Author

I was trying that...but I couldn't figure out how to do that AND transpose them to get a transactional database...any ideas?

rwunderlich

‌I'm not understanding how you want yo transpose the data. Can you give an example?

dcohen13
Contributor III
Contributor III
Author

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.

MarcoWedel

please post your expected result

regards

Marco

rwunderlich

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

dcohen13
Contributor III
Contributor III
Author

Indeed, one transaction per file, i'll try this!