Log File Load - Need to Keep Blank Records

[dcohen13]

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

[maxgro]

try with a fixed lenght load

LOAD

  [@1:100] as field

FROM

Log_File_Blankrecords.txt

(fix, codepage is 1252);

[dcohen13]

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]

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]

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