Can we add a new column to excel by use QV script?

[#1]

Hi all,

I have the excel file that has 2 column , but I need to add 1 column by use the condition from other column.

I use if function and I know that not solve my problem .

if(LEVEL = 1,MAT) as ParentMAT --> this not fill all rows in the new column.

I already attach example file. Please someone suggest me.

Thanks for advance.

Tatar

[nathanfurby]

Are you talking about directly adding a column to an Excel file?

Also - your attachment does not appear to be an xls file and so generates a warning error.

[#3]

Hi NathanFurby,

I mean like I need to clean the source that come from excel file and save its to qvd file. In my qvd file should has a new column.

And this is my problem, I try to make a new field into qvd file. But still don't know how?

And I already attached a new file, hope you can see its.

Thank you for your respond.

Tatar

[nathanfurby]

OK - I see the problem. I'm sure there is a way to work it out. But I see this as a data issue. Is there no better way to relate the data at the source? such as this:

level mat
1 1
2 1a
3 1b
4 1c
5 1d
6 1e
1 2
4 2a
5 2b
6 2c
7 2e
1 3
2 3a
3 3c