Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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 (2)
0 Replies