Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
arvinserco
Contributor II
Contributor II

Take few columns from different sheet by using unique column in both

Hi all

I need to create a calculated field to take data from different sheet by using a particular column. How to do that?

Regards,

Arvind

6 Replies
dilipranjith
Partner
Partner

Need a lot more information. Can you give sample data?
nilaksh92
Partner
Partner

Could you please share sample data or sheets?

arvinserco
Contributor II
Contributor II
Author

Hi Dilip,

Please find attached Sample file.

Consider A & B as two different tables in Qlik sense.

I need to create a calculated field to update Age, Extension # & Country/State  in Table B with Name as unique.

(Example: Just we do by using Vlookup function in excel).

Regards,

Arvind

dilipranjith
Partner
Partner

Not sure what you mean by "calculated field to update Age, Extension # & Country/State"
basically if you load the 2 tables mentioned into qlik it will be automatically linked by the column Name (similar to foreign keys in Database)
or you can join the tables to create a single one
arvinserco
Contributor II
Contributor II
Author

I don't want to create any link between these table just want to take those columns from Table A.
nilaksh92
Partner
Partner

Hi,

 

Load table A;

Load table B rename Name column;

join with table new table which will b resident of table A with different column  names

Renaming of fields need to be done in resident table so that it should not associated with table A.

 

Please find the attached file for your reference.

 

Hope this might help you.