topic Conditional Loading of Data in QlikView

Conditional Loading of Data

Wed, 23 Dec 2009 13:54:46 GMT

Hi,

Let me explain my problem with an example:

File A - contains name and age of all student in a class

File B - contains address of all the students in the school

I want a qlikview with name, age & adddress of the student of the class & hence I want to load the address of the students who are in that particular class and not for all the students in the school

Should be a simple query, But i would be really garteful if someone can helo me out

thanks 🙂

Conditional Loading of Data

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 14:41:59 GMT

Hello,

Try with

LOAD ... FROM Table WHERE ClassNameField = 'A'

Where "..." are the fields you want to get, Table is the table or file where your datasource is located and ClassNameField the name of the field where you store students's addresses.

Let us know if this worked.

Regards.

Conditional Loading of Data

Wed, 23 Dec 2009 14:51:33 GMT

Hi,

thanks for the reply, but in my case there are other fields as Parents Name, Nationality etc in the 2nd file and the Key Term linking both the files is the 'NAME'and I want all the details of the student loaded form file B

Conditional Loading of Data

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 14:59:15 GMT

Hi,

To link two fields in QlikView the only thing you need is to name two fields identically. But you may need a inner join load, so we need your field definition in order to help you.

But for what you are telling, and having that the field "NAME" exists in both tables with the same name and data, and that the rest of the fields in both tables have different names the load would be something like

LOAD * FROM TABLE1 WHERE ClassFieldName = 'A';
INNER JOIN
LOAD * FROM TABLE2;

Conditional Loading of Data

Wed, 23 Dec 2009 15:11:22 GMT

I guess i am quite new to qlikview and not able to understand scripting easily , I am attaching aan excel file with dummy data in two sheets

Sheet1 - has Name & Age

Sheet2 - has Name, Addresss & Father

I need to load Sheet1 fully & from Sheet2 Address & Father of only those people who are present in Sheet1, if you can give me specific solution for the same would be a great help

thanks

Conditional Loading of Data

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 15:19:49 GMT

Here you are the sample code. Please note that the load is being done from Excel sheets, so you will need to change the FROM clause in any case.

Table1:LOAD Name, AgeFROM[A.xls](biff, embedded labels, table is Sheet1$);INNER JOINLOAD Name, Address, FatherFROM[A.xls](biff, embedded labels, table is Sheet2$);

Conditional Loading of Data

Wed, 23 Dec 2009 15:33:11 GMT

Thank You for the code, really appreciate it, I have been able to replicate the same