topic Re: if condition in load script in QlikView

if condition in load script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have two Fields

FieldA has two values A and B

FieldB has Y and N

FieldC has numbers.

I am trying to fetch values from FieldC based on condition on FieldA and FieldB in the Load Script as below:

if([FieldA]='A' and [FieldB]='Y', [FieldC])

If FieldA has A and FieldB has Y as values, then the column FieldC should get all the values corresponding to the condition. But I get this error saying Invalid Expression. How to achieve this in Load Script level.

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 14:47:29 GMT

I don't see any issue with you if statement. Are you doing this within the LOAD statement right?

LOAD if([FieldA]='A' and [FieldB]='Y', [FieldC]) as RequiredField

Re: if condition in load script

swuehl — Tue, 19 Apr 2016 14:49:32 GMT

All three fields need to be part of your input table, they can't reside in separate tables. Is this true?

Then, could you post your complete LOAD statement? It's hard to tell why you get the error message without seeing the full context.

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 14:56:26 GMT

UPDATE:

Field1, Field2 and Field3 are coming from the same table, Table1.

I am using this in the load of a new table:

Table2:

Load

Field1,

Field2,

Field3,

if(Field1='A', and FieldB='Y', then Field3) as [DefinedValue]

Resident Table1;

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 15:23:54 GMT

Is it possible to take two fields from two different tables and use them in a third table using Resident load?

For example,

Field1 from Table1

Field2 from Table2

Table 3:

(Should have Field 1 and Field2).

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 16:04:54 GMT

if(Field1='A' and FieldB='Y' or 'N', Field3) as [DefinedValue]

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 16:07:10 GMT

Try this:

If(Field1='A' and Match(FieldB, 'Y', 'N'), Field3) as [DefinedValue]

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 16:07:38 GMT

After you join them using JOIN functionality

Re: if condition in load script

swuehl — Tue, 19 Apr 2016 16:07:50 GMT

DRJ DJ wrote:

Is it possible to take two fields from two different tables and use them in a third table using Resident load?

For example,

Field1 from Table1

Field2 from Table2

Table 3:

(Should have Field 1 and Field2).

No, not without using inter record functions, like lookup(). Or maybe a MAPPING.

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 16:08:11 GMT

This works in the Load script?, Sunny

Re: if condition in load script

swuehl — Tue, 19 Apr 2016 16:08:35 GMT

if(Field1='A', and FieldB='Y', then Field3) as [DefinedValue]

if(Field1='A' and FieldB='Y' or FieldB = 'N', Field3) as [DefinedValue]

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 16:12:42 GMT

Yes, I would think so. Is it not working?

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 16:42:50 GMT

I don't see any error. But I see that the conditions are not being evaluated. The resultant field is showing incorrect values.

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 17:01:53 GMT

Can you explain your condition in plain simple English?

Re: if condition in load script

vikramv — Tue, 19 Apr 2016 17:26:28 GMT

I guess , you need to use DUal function like this.

Dual & Exists – Useful Functions

Thanks.

Vikram

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 18:09:21 GMT

I need to check for a value in Field1, check for two values in Field2 ( Like A or B) and then depending on the conditions, I should display the value present in Field3 as DefineValue columm.

I hope you got it, Sunny

Re: if condition in load script

vikramv — Tue, 19 Apr 2016 18:31:24 GMT

Check this from the help that may help you

lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])

Returns the value of fieldname corresponding to the first occurrence of the valuematchfieldvalue in the field matchfieldname.

Fieldname, matchfieldname and tablename must be given as strings (e.g. quoted literals).

The search order is load order unless the table is the result of complex operations such as joins, in which case the order is not well defined.

Both fieldname and matchfieldname must be fields in the same table, specified bytablename. If tablename is omitted the current table is assumed.

If no match is found, null is returned.

Example:

lookup('Price', 'ProductID', InvoicedProd, 'pricelist')

Re: if condition in load script

sunny_talwar — Tue, 19 Apr 2016 18:40:55 GMT

I would think this to work:

If(Field1='A' and Match(FieldB, 'Y', 'N'), Field3) as [DefinedValue]

Would you be able to share a sample where this isn't working?

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 18:41:46 GMT

Sorry Vikram, I need to check for two values in Field2. It's not just one value in Field1. This thing doesn't work in this case.

Conditions example:

if Field1 has X

if Field2 has Y or N,

then Field3 as DefinedValue.

In this case, you maybe able to do it for one value, but I need to check for two values in the Field2

Re: if condition in load script

Anonymous — Tue, 19 Apr 2016 19:34:34 GMT

The sample data i can provide is the same examples I have been using, Sunny. My original data is too complicated and also, privacy issues. So I will try it from my end and will get back if I can't figure it out. Thanks again