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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Prasanna3
Contributor
Contributor

Reading CSV Feed dynamically

Hi
I have CSV feed like below.

I want to read that schema dynamically when columns having double quotes.

"empno","ename","sal","deptno","location"
100,Sam,500,10,Hyderabad
200,pras,600,20,mas.

Please someone provide me solution for this.i tried everything it didn't worked for me.
Labels (2)
2 Replies
sraoul2002
Contributor
Contributor

Hello,

you have 2 solutions :

 

1- read the csv file without the header (if the header is the only line which have the double quotes)

2- Read all column of the csv file as String and remove the double quotes in tmap : varString.replace("\"","")

//varString is the fied name of your string.

 

let us know if you have issue anymore.

Regards

 

Prasanna3
Contributor
Contributor
Author

My scenario is I should read by using dynamic feature