Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator

## Error in field names when storing to QVD

Hi,

If have a number of fields in 1 particular table for witch the name of the field is not correctly saved in the qvd table.

Example:

I have in a load statement the following conditions:

......

If([Amount TOT.]<ApplyMap('MapAVG_Account_Period', ACJM,'No Data'),1,0) as [< AVG],

If([Amount TOT.]>ApplyMap('MapAVG_Account_Period', ACJM,'No Data'),1,0) as [> AVG],

If([Amount TOT.]<='1,5',1,0) as [>0 & <= 1,5],

If([Amount TOT.]>'1,5' and [Amount TOT.]<='5',1,0) as [>1,50 & <= 5],

If([Amount TOT.]>'5' and [Amount TOT.]<='10',1,0) as [>5 & <= 10],

If([Amount TOT.]>'10' and [Amount TOT.]<='15',1,0) as [>10 & <= 15],

If([Amount TOT.]>'15' and [Amount TOT.]<='20',1,0) as [>15 & <= 20],

If([Amount TOT.]>'20' and [Amount TOT.]<='25',1,0) as [>20 & <= 25],

If([Amount TOT.]>'25',1,0) as [>25]

After the store table to qvd command the field names become:

[&lt; AVG], instead of [< AVG]

[&gt; AVG], instead of [> AVG]

[&gt;0 &amp; &lt;= 1,5], instead of [>0 & <= 1,5]

[&gt;1,50 &amp; &lt;= 5], instead of [>1,50 & <= 5]

[&gt;5 &amp; &lt;= 10], instead of [>5 & <= 10]

[&gt;10 &amp; &lt;= 15], instead of [>10 & <= 15]

[&gt;15 &amp; &lt;= 20], instead of [>15 & <= 20]

[&gt;20 &amp; &lt;= 25], instead of [>20 & <= 25]

Can this be solved because i need the field names as they are. (ex: [>0 & <= 1,5])

In the load script from the qvd file i use the names as they appear in the qvd file:

[&lt; AVG],

[&gt; AVG],

[&gt;0 &amp; &lt;= 1,5],

[&gt;1,50 &amp; &lt;= 5],

[&gt;5 &amp; &lt;= 10],

[&gt;10 &amp; &lt;= 15],

[&gt;15 &amp; &lt;= 20],

[&gt;20 &amp; &lt;= 25],

[&gt;25]

and then i get an error saying for example, "field not found <&lt;AVG> and so on.

Can this be solved and how?

I realy need the given names like [< AVG], for the field names to be as they are because those field names are used in other programs.

1 Solution

Accepted Solutions
Creator
Author

Hi,

I have found the solution myself.

If i use the original names (ex: [< AVG]) in the load script from the qvd files instead of [&lt; AVG], everything works fine.

5 Replies

Can you share the script file?

Creator
Author

Hi,

I have found the solution myself.

If i use the original names (ex: [< AVG]) in the load script from the qvd files instead of [&lt; AVG], everything works fine.

Creator
Author

It is ok, i have found the solution myself.

Thanks anyway.

Greetings

Partner - Champion III