Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
dplr-rn
Partner - Master III
Partner - Master III

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

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

dplr-rn
Partner - Master III
Partner - Master III

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 - Contributor III
Partner - Contributor III

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.