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

filter with column names as list of values and link with main table

I have a dataset with 700 columns which i need to put in a qliksense report with a custom report extension.

I need to categorize columns in different sets so those set name will be used as Filter object with those same category column names. for Example 

DATA:

Employee_NmEmployee_AgeEmployee_DesgEmployee_IDEmployee_RgnCompany_IDCompany_NameCompany_RegnCompany_LOBCompany_age
John35MD1234NAABCHappy PlaceNAHR20
Peter36MD1235NAABCOK PLACENAIT21

 

Filters required :

EmployeeClient
Employee_NmCompany_ID
Employee_AgeCompany_Name
Employee_DesgCompany_Regn
Employee_IDCompany_Add
Employee_RgnCompany_age

 

I can load the data,  i can club the columns with inline load but only problem i am facing how i can link the main data table with my inline load table.

i can use get field selection function but doing it for 700 columns doesnt make sense, So i am looking for some robust script logic which can help in linking my filter with my main table .

 

Labels (3)
0 Replies