few qestions

[#1]

Dear all,

I have few question

1.Is it possible to load my qvw results to any odbc database?.

2.In my source file .csv I have value 123.456655.I want values only till two decimal places (like 123.45).

3.I want to load data to Qvd with 5 Column's  where I have only 4 column's (Column1,Column2,Column3,Column4) from source  file

the extra column should come with null values to Qvd.

     If it possible,help me on this

Thanks in advance,

b.kasi

[PrashantSangle]

Hi,

2: Use Num(fieldName,'##,00.00') for rounding upto 2 decimal.

3: Try script like

Load field1,

field2,

field3,

field4,

'Null' as field1

from qvdName.qvd;

1: I think through Macro it is possible, But I am not sure about it.

Any Macro expert will help you on this requirement.

Regards

[SunilChauhan]

1)yes using Extention write back to database

2) Num(123.456655,'#.##') or fixed to 2 in number Tab of chart properties

3)

tab:

Load

Column1,Column2,Column3,Column4,

'' as Column5

from path

store tab into path\tab.qvd

[tresesco · Accepted solution]

1. Yes you can. For 'how?', search this community with 'write back to database'

2. Use num(), like num(yournum, '##.##')

3. Possible, Try like:

          Table:

          Load

               Col1,

               ....,

               null() as Col5

          From <>;

          Store Table Into ..;

[jagan]

Hi,

Check this link to write to database in script

Inserting records into Database using Qlikview Script

Write Back to Database via ETL process (using CSV or XML)

Regards,

Jagan.

[its_anandrjs]

Hi,

Yes you can do this

1. By Macros and search write back to databse in qlik community

Few of them are

http://community.qlik.com/message/609774#609774

Write Back to Database via ETL process (using CSV or XML)

2. For Decimal two place use

Load

Num( FieldName, '#.##0,00')

From Source

OR

Load

Num( FieldName, '#.##')

From Source

3. And for Loading null columns use

Load Field1,Field2,Field3,Field4, Null() as Field5,Null() as Field6

From Source;

Regards

Anand