Evaluate Variable in Formula String in Table Field

[hugmarcel]

Hi

1.) I have Table Field T.X with string value: "INTERVAL($(TalkTime)/(60*60*24),'hh:mm:ss')"
2.) Variable TalkTime has content:               "Sum([TALK.Time])"

Goal is to create new Field T.Y having content: "INTERVAL(Sum([TALK.Time])/(60*60*24),'hh:mm:ss')",
using a Script function during load.

Any idea?

Thank you! Marcel

[marcus_sommer]

I think you will need to pick these field-content per peek(), lookup() or fieldvalue() into a variable and used then these variable in your load, maybe like this:

...

let exp = peek('T.X', 0, 'expTable');

t1:

Load *, $(exp) as newField From xyz;

....

- Marcus