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: 
Nethu_Rajapaksha
Contributor II
Contributor II

How to separate columns and fix the data in to correct format?

Hello experts,

In my excel sheet I can see Plugin ID, CVE, CVSS, Risk, etc as separate columns. But when I upload that CSV into Qlik in shows as fallowing (all in one column). I want to see that what I see it in excel sheet as separate columns. How do I solve this issue? as well as the data also has changed. how do I fix it? 

In the Excel Sheet:

excl.JPG

In the Qlik sense:

qlik.JPG

I would really appreciate it if you could help to solve this issue.

Thank You.

1 Solution

Accepted Solutions
Rohan
Partner - Specialist
Partner - Specialist

Hi @Nethu_Rajapaksha ,

Check the delimited by, while inserting the script in the load editor.

 

Regards,

Rohan.

View solution in original post

2 Replies
Rohan
Partner - Specialist
Partner - Specialist

Hi @Nethu_Rajapaksha ,

Check the delimited by, while inserting the script in the load editor.

 

Regards,

Rohan.

Nethu_Rajapaksha
Contributor II
Contributor II
Author

Hi @Rohan ,

Thank you so much for your help! Your solution worked perfectly and saved me a lot of time.!