topic Re: Create a separate field/table in QlikView

Create a separate field/table

Anonymous — Mon, 12 May 2014 08:03:50 GMT

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

Re: Create a separate field/table

IAMDV — Mon, 12 May 2014 08:13:35 GMT

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,

www.QlikShare.com

Re: Re: Create a separate field/table

Anonymous — Mon, 12 May 2014 08:30:40 GMT

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

Re: Create a separate field/table

anbu1984 — Mon, 12 May 2014 08:32:47 GMT

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;

Re: Re: Re: Create a separate field/table

anbu1984 — Mon, 12 May 2014 08:36:47 GMT

Try this

Re: Create a separate field/table

Anonymous — Mon, 12 May 2014 08:45:21 GMT

Thanks a Lot Boss.It worked