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

[#1]

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

[rajeshvaswani77]

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

thanks,

Rajesh Vaswani

[#3]

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

[#4]

Hello

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

[marcus_sommer]

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

[#6]

Hello,

The solution is

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

[#7 · Accepted solution]

Thanks everyone for the helpful suggestions!

I have this one sorted out now.

Best regards, to all,

Steve