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_Nm
Employee_Age
Employee_Desg
Employee_ID
Employee_Rgn
Company_ID
Company_Name
Company_Regn
Company_LOB
Company_age
John
35
MD
1234
NA
ABC
Happy Place
NA
HR
20
Peter
36
MD
1235
NA
ABC
OK PLACE
NA
IT
21
Filters required :
Employee
Client
Employee_Nm
Company_ID
Employee_Age
Company_Name
Employee_Desg
Company_Regn
Employee_ID
Company_Add
Employee_Rgn
Company_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 .