Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In the load script of the qv file (in attachment) I want to add a new calculated field
NetWorkDays
([Datum 1: Lancering Workflow],[Datum 7: Finale goedkeuring],) as [Doorlooptijd in werkdagen (etappe)]
,'##,00',
During the reload I got the message : Field names must be unique within table MainTable:
I don't see the problem.
Can somebody help me ?
Qv in attachment.
Thanks in advance
Marc
NetWorkDays(1,2,) as [Doorlooptijd in werkdagen],'##,00',
The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error. I have no idea what you intended that '##,00' to do, but it doesn't do anything useful and is causing the error you see.
Hi Marc,
Unable to open the file, will u pls provide some sample data.
Thank you
Regards,
Sub2u.
Hi
Problem is in the mean while solved by Gysbert Wassenaar.
Problem was:
The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error.
Thanks a lot.
Merry Chrsitmas and Happy New Year.
Marc
Hello Gysbert
Thanks a lot. Indead '##,00', is useless.
Is removed and OK.
Merry Chrsitmas and Happy New Year.
Grt
Mar
Merry Chrsitmas and Happy New Year to you too!
Can you mark this discussion as Answered?
Hi Gysbert
Ok. Normally I can mark the response as “Juiste oplossing” but this is not available.
How can I mark this discussion as answered ?
Thanks a lot.
Marc