How to get the data.

[abc_18]

Hi,

I am having two table.

In one table I have information about the students like

student ID, Age,Class,Name

and another table I am having only student ID of those student who has failed.

now my question is how to get data about those students who has passed the examination.

[aarkay29 · Accepted solution]

May be this

//From Students Failed Table

Failed :

load StudentID as StudentID_Failed

From Students Failed;

//From Students Info table

Passsed:

Load StudentID as

From Students

Where Not Exists(StudentID_Failed);

[prat1507]

TablePassed:

Load From Table1

Where Not Match(Customer, 'A','B','C');

TablefAIL:

Load * Inline [

Student Id

101

102

];

Table1:

Load * Inline [

Student Id, Age, Class, Name

101, 1,1,A

102, 1,2,B

202, 2,2,C

200, 2,2,D

201, 2,1,E

] where not Exists(Student Id);

[el_aprendiz111]

Hi,

DATA:
LOAD * Inline
[
student ID, Age,Class,Name
1,11,M,AZ
2,12,N,QSC
3,10,H,WDV
4,13,J,EFB
5,9 ,O,RGN
];

DATA2:
LOAD * Inline
[
student ID
3
4
];

ID:
LOAD Concat(DISTINCT [student ID],',') AS stdID Resident DATA2;
LET vStudentId = Peek('stdID');

SUMARY:
LOAD *, RecNo() AS ID Resident DATA Where not Match([student ID],$(vStudentId));


DROP Table ID, DATA, DATA2;

Age	Class	Name	student ID
11	M	AZ	1
12	N	QSC	2
9	O	RGN	5