Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Community!
I'm new to QV and exploring my way around. I've learned several tricks so far and I'm hoping someone can help me with a minor issue.
Twice now, after I've created a new field in one of a few tables I've loaded and attempted to re-format or include in downstream calculations, I get the Script Error: 'Field Not Found - <My Field>.
The examples are
Key_Table:
Mapping LOAD [Old Entitlement Key] as [Entitlement Key],
[Sales Order Date]
FROM ....excel file
All_Data:
LOAD [Bill To],
[End User],
[Old Entitlement Key],
[Item: Name],
[Entitlement Key],
ApplyMap('Key_Table',[Entitlement Key],'') as [Renewed On 2],
Year([Renewed On 2])&'-'&'Q'& Ceil(Month([Renewed On 2])/3) as [Renewed On Quarter 3]
FROM ....excel file
And here are my failed attempts for resolution are:
Any recommendations or insights would be appreciated!!
Thanks QV community!
Thank you Luis!!!
Learning new things everyday! Thanks for all your help!