Add calculated field in the load script

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

Hi Marc,

Unable to open the file, will u pls provide some sample data.

Thank you

Regards,

Sub2u.

[#4]

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

[#5]

Hello Gysbert

Thanks a lot. Indead '##,00', is useless.

Is removed and OK.

Merry Chrsitmas and Happy New Year.

Grt

Mar

[Gysbert_Wassenaar]

Merry Chrsitmas and Happy New Year to you too!

Can you mark this discussion as Answered?

[#7]

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