script

[francofiorillo]

Hi.

help.

I have a database table "Tab_Input".

I select only the rows where the value in column 2 is not present in column 1.

I would like to get the "Tab_Result" shown on the sheet.

thanks.

[MK_QSL · Accepted solution]

Temp:

Load *, Col1 as TempCol1 Inline

[

  Col1, Col2

  P, F1

  P, F2

  F1, F11

  F1, F12

  H, F3

  H, F4

  F3, F31

  F3, F32

  F3, F33

];

NoConcatenate

Final:

Load * Resident Temp Where Not Exists (TempCol1,Col2);

Drop Field TempCol1;

Drop Table Temp;

[francofiorillo]

sorry but I am not clear.

you can give me an example?

[maxgro]

use Manish script (just replace the inline load with a load from excel) and you'll get the output you want