topic Re: Log File Load - Need to Keep Blank Records in QlikView

Log File Load - Need to Keep Blank Records

dcohen13 — Tue, 26 Jan 2016 14:42:25 GMT

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

Re: Log File Load - Need to Keep Blank Records

maxgro — Tue, 26 Jan 2016 18:28:11 GMT

try with a fixed lenght load

LOAD

[@1:100] as field

FROM

Log_File_Blankrecords.txt

(fix, codepage is 1252);

Re: Log File Load - Need to Keep Blank Records

dcohen13 — Tue, 26 Jan 2016 20:15:09 GMT

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

Re: Log File Load - Need to Keep Blank Records

rwunderlich — Thu, 28 Jan 2016 16:17:08 GMT

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

Re: Log File Load - Need to Keep Blank Records

dcohen13 — Fri, 29 Jan 2016 19:46:46 GMT

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.

Re: Log File Load - Need to Keep Blank Records

MarcoWedel — Sat, 30 Jan 2016 01:25:25 GMT

please post your expected result

regards

Marco

Re: Log File Load - Need to Keep Blank Records

rwunderlich — Sat, 30 Jan 2016 19:19:48 GMT

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

Re: Log File Load - Need to Keep Blank Records

dcohen13 — Tue, 02 Feb 2016 18:31:19 GMT

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