Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .