Table loop

Mon, 02 Jul 2012 14:41:46 GMT

Hello everyone

I need your help with something

I have a number of fields in a table, let's say I have a field1 and Field2 , i need to create a new column called condition .

for each value in Field1 if Value exists in Field2 than condition=0, else condition=1.

Thank you in advance for your help

Re: Table loop

jonathandienst — Mon, 02 Jul 2012 14:50:37 GMT

In your load script, assuming that you have loaded Field2 first:

LOAD

...

Field1,

If(Exists(Field2, Field1), 0, 1) As Condition,

...

From ...;

You could also do this with join using the table containing Field1.

Hope that helps

Jonathan