Value could not be converted

d_schneider — Wed, 06 Jan 2021 15:12:19 GMT

Hello community,

I tried to move a QLIKview document to sense, but it brings an error:

In a loop tables from different mandators should be loaded. In the first step, i create an empty table:

qualify *; //Postfix für Tabellennamen

// Reset all data:
workareas: load '' as Dummya Autogenerate(0);
orders: load '' as Dummyb Autogenerate(0);

Then I start the loop along the before loaded tablellist:

For i = 1 to $(vfound_tables)-1

let vfile=peek('av.name',$(i), 'tablelist');
let vtab= peek('Tabelle',$(i), 'tablelist');
let vmand=peek('mand',$(i), 'tablelist');
let BJahr=Mid('$(vfile)', index('$(vfile)','_')-4,4);

$(vtab):
Concatenate ($(vtab))
LOAD
Num#($(vmand),'#0') as mandator,
$(Byear) as Byear,
*
;
SQL Select * From "dbo"."$(vfile)";

If mod(i,10) = 0 Then
trace tableNr. ($(i) geladen von $(vfound_tables));
Endif

Next i;

I get the error by the first table in trying to concat data in the loop:

The fllowing Error occured:

The value 'System.Byte[]' could not be converted to type double

The Error occured here:

Workareas:

Concatenate (Workareas)

LOAD

Num#(1,'#0') as mandator,

2011 as Byear,

Any Ideas that can help?

Best Regards

Daniel

topic Value could not be converted in Connectivity & Data Prep

Value could not be converted