Field not found

[#1]

Hi guys,

I'm having this really weird problem. I don't know what's wrong with my script. It worked  and I could build some visualizations on the data I'd loaded, but now I get this weird mesage saying "Field not found". I didn't change anything in the script, but who knows if I accidentaly erased something. That happens to anyone. Can you take a look at my script and say if something looks strange?

The field that isn't found is iOrderItemId, which is weird since that field is in the orderitems qvd file.

As I said, the data loaded perfectly fine until now. A little help would be awesome!

Sincerely,

Betty

[roger_stone]

That field is listed twice in the load statement.

[roger_stone]

See here:

[brunobertels]

Hi

First

iOrderItemId is listed twice as Roger said

but may be try this

[iOrderItemId] as iOrderItemId,

[#5]

Thank you for replying!! I tried fixing it by erasing it, so there only was one iOrderItemId left, but it didn't work. However after trying so many things, my colleague helped me out by erasing everything and just loading everything from scratch (good thing it wasn't much!). That fixed the problem.

Thank you again for anwering so quickly 😃

Sincerely,

Betty