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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hafaneh
Contributor III
Contributor III

I have unstructured excel data i want to show it in qlik as a structured data

Hello,
I need this unstructured data to be shown as structured data 

The fields are ( name/date/KD/extra stuff/stuff/ stuff not/stuff on/sum) 

here a sample of how the data look in excel 

     
     
name  XXXX  
date XX/xx/XX  
     
     
stuff    
extra stuff KD 
1   232
2   233
3   234
4   235
5   236
6   237
7   238
sum    324242
     
stuff not    
1   322
2   323
3   324
4   325
5   326
6   327
7   328
sum   329
sum of stuff 330
     
all    
stuff on     
1   1342
2   1343
3   1344
4   1345
5   1346
6   1347
7   1348
sum   1349




0 Replies