topic Re: script in Archived Groups

script

francofiorillo — Wed, 23 Jul 2025 14:48:52 GMT

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 — Sat, 11 Oct 2014 11:09:11 GMT

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 — Sat, 11 Oct 2014 11:40:54 GMT

sorry but I am not clear.

you can give me an example?

maxgro — Sat, 11 Oct 2014 12:46:20 GMT

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