Adding a where clause in a data load on a left join

[Kelly_Anne001]

I am very new to Qlik sense and data load scripting and have come across a challenge that is giving me some trouble in the way my data is presenting.

The Left Join works, however, I only need to join where there "-" does not exist in the field I am using to link the two data sets, and I need to prevent duplicating the line items after joining.

[Aditya_Chitale]

you can use where not wildmatch (yourfield , '-') in your second table.

eg:

test:

load

.

.

.

from [xyz.qvd](qvd)  where not wildmatch (yourfield,  '-') ;

Regards,

Aditya

[Kelly_Anne001]

Thank you so much.
It still does not seem to work so I do not think that is where the problem is. 

Let me do some more playing around. 

Thank you so much!

[Chanty4u]

Try this example

Table1:

LOAD Field1, Field2

FROM DataFile1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Table2:

LOAD Field3, Field4

FROM DataFile2.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE NOT WildMatch(Field3, '*-*');

LeftJoin:

LOAD Field1, Field2, Field4

RESIDENT Table1

LEFT JOIN

Table2

WHERE NOT IsNull(Field3);

DROP TABLE Table1, Table2;

[Kelly_Anne001]

Thank you so much.

I will give it a try and let you know how it goes.

I am still learning and playing around with it.