String Matching using loop

Wed, 14 Apr 2010 19:41:56 GMT

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

String Matching using loop

Thu, 15 Apr 2010 07:00:54 GMT

Hi,

Check the attached file.

Hope this will help you.

- Sridhar

String Matching using loop

Thu, 15 Apr 2010 15:20:42 GMT

Sridhar,

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

topic String Matching using loop in QlikView

String Matching using loop

String Matching using loop

String Matching using loop