Create a separate field/table

[Anonymous]

Dear Team,

I want to create a new table/field by comparing fields in two different tables.

Example

Table I : User ID : Jebamalai.Pushparaj

Table II : User ID : Jebamalai.Dass

These two have same employee ID in both fields.

I want to generate a table/field where User IDs are different for the same employee IDs

Kindly guide me.

Regards

Jeba

[IAMDV]

I assume you wanted to do it in the UI instead of script. I'd suggest using straight table with simple IF statement comparing both the fields. Post your sample app and one of us can mock up something for you.

Cheers,

DV

www.QlikShare.com

[Anonymous]

Hi Deepak,

Please find attached the sample data.

I have created two tables.

Base 1 and Base 2 are the same kind of tables connected by ID.

I want to list the users who has different mail IDs compared between.

In this User2 has different mail ID which I want to list in another table.

Let me know if you need more detail.

Regards

Jeba

[anbu1984]

In Script

Emp1:

Load * Inline [

EmpId,Nm

1,Jebamalai.Pushparaj

2,Raj ];

Join(Emp1)

Emp2:

Load * Inline [

EmpId,Nm1

1,Jebamalai.Dass

2,Raj ];

Final:

NoConcatenate

Load EmpId, Nm, If(Nm <> Nm1,Nm1) Resident Emp1;

Drop table Emp1;

[anbu1984 · Accepted solution]

Try this

[Anonymous]

Thanks a Lot Boss.It worked