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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Integrating Seperate Columns in to one Column

Hi
I have a csv file which have follwong fields.
timestamp;var1_min;var1_max;var1_avg;var2_min;var2_max;var2_avg;var3_min;var3_max;var3_avg
and I would like to create a table fromt this file as follows
Timestamp Variable Min Max Average
####### 1 - - -
####### 2 - - -
####### 3 - - -

So the question is how i can integrate the min max and average values of different variables in to one column with respect to column variable and timestamp.
Thank You in advance
Labels (2)
11 Replies
Anonymous
Not applicable

Thanks a ton shong
0683p000009MACn.png
alevy
Specialist
Specialist

From v4.2.0, the tSplitRow component handles this very well.