Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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