topic Re: Having problems with Creating new column in Document Load Wizard in QV in QlikView

Having problems with Creating new column in Document Load Wizard in QV

Mon, 26 Aug 2013 16:30:00 GMT

I have a spreadsheet that is divided into sections by some data that I would lik eto turn into a column. In the load Wizard, i have removed the Header lines (no problem) and I went to create a new column using information from specific rows in the spreadsheet.

I have done this every way that I can think of but it won't pull the data into the QV.

Here are the steps that I take in pictures:

I create the new column based upon similar but different values in column 1 and recreate them in column 19:

Next I use the "Fill" tool to copy each entry in column 19 down to the next value:

This populates the rest of the column:

Then I just complete the wizard:

The data shows in column 19 through each step of the Wizard:

But when I load the script, the column number is there, but it contains no data:

What am I doing wrong? shouldn't this tool do what i am trying to do?

Steve

Re: Having problems with Creating new column in Document Load Wizard in QV

rajeshvaswani77 — Mon, 26 Aug 2013 16:34:15 GMT

I can see Replace(19, top, StrCmd(Null), was that intended?

thanks,

Rajesh Vaswani

Re: Having problems with Creating new column in Document Load Wizard in QV

Mon, 26 Aug 2013 19:29:53 GMT

Not sure how to answer that. I used the Wizard and that is the code tha the Wizard generated. My intention is to create a new column and populate it with specific rows of data that appear in column 1. Everything looks correct in the wizard and it does create column 19 but there are not data in column 19 in the QV doc.

Since the screen shots are hard to read, i have attached them here separately to make them easier to read.

Steve

Re: Having problems with Creating new column in Document Load Wizard in QV

Mon, 26 Aug 2013 20:50:10 GMT

Hello

What name colum number with values 147,146,145,144,143,142,... ?

Re: Having problems with Creating new column in Document Load Wizard in QV

marcus_sommer — Tue, 27 Aug 2013 11:11:49 GMT

Hi Steve,

I would remove this statement-part: Replace(19, top, StrCmd(Null)). These are special functionalities which are bad documented. Alternatively you could write a load-statement without the wizard and use the peek()-function to fill out - it is similar to Re: Loading spreadsheets with different formatting

- Marcus

Re: Having problems with Creating new column in Document Load Wizard in QV

Thu, 29 Aug 2013 19:54:45 GMT

Hello,

The solution is

If(IsNull([@19]) or Trim([@19]) = '', Peek('@19', -1), [@19] ) as [@19]

Re: Having problems with Creating new column in Document Load Wizard in QV

Fri, 30 Aug 2013 11:56:29 GMT

Thanks everyone for the helpful suggestions!

I have this one sorted out now.

Best regards, to all,

Steve