String Matching using loop

[#1]

Just started with QlikView development.

Trying to do wild card comparison for columns in two tables. I need to list out the values that are in one column but not in another.

Tbl1

ColumnA

Alex Jan

Rob Marc

Josh Apr

Chris Feb

Tbl2

ColumnB	ColumnC
Chris	Feb
Alex	Jan
James	May
Mike	Jun

I am trying to come up with data in ColumnA but not in ColumnB and vice versa. I am putting this as the tablebox calculation condition, but it is not working, am I completely off course?

LET NrRows = NoOfRows('Tbl1');

LET NrRows2 = NoOfRows('Tbl2');

LET k = 1;

DO WHILE r<=NrRows

LET i=0;

DO WHILE i<NrRows2;

ColumnA like ColumnB&'?'&CoumnC&'*' = -1

i=i+1;

LOOP

k=k+1;

LOOP

[#2 · Accepted solution]

Hi,

Check the attached file.

Hope this will help you.

- Sridhar

[#3]

Sridhar,

Thanks. This helps and I will try to do it from the load page.