using variables in edit scripts

[#1]

Hi,

Can I use variables in edit script to add extra column??

Thanks,

[#2]

Hi Tim,

short answer: YES.

Let vMyVariable =1;

Let vMyVariable2='Counter';

Load

$(vMyVariable1) as $(vMyVariable2),

Field1

From .........

Please see QV Help and search for LET and SET.

Good luck!

Rainer

[#3]

I have one excel sheet with the following fields Product, Qty, Price. I want to calculate Total Amount while creating the table box.
Its not possible to use expression if I want table object, so I decided to create variable and use it in the table box, but I am not sure how to do this

As you said use LET and SET options, but I am not that much familiar with this tool.

Kindly assist.

Thanks,

[#4]

Hi Tim,

use a table diagram instead of a table box.

The main difference is that you are able to place expressions by using a table diagram.

Good luck!

Rainer