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: 
microwin88x
Creator III
Creator III

Load Fields with Pipe Chart

Hello,

I read a file that has the following data:

 

Name|Type|Require Vendor|Active|Created Time|Created By
Course|Plan SX|False|True|01/03/2016 20:38|Jack Johnson

What I need is to load that information, creating those fields and values in my data model.

How would you do that?

Thank you!

1 Solution

Accepted Solutions
microwin88x
Creator III
Creator III
Author

Yes! Just solved it by doing this:

LOAD Field1,Field2,Field3

FROM File.csv (txt, utf8, embedded labels, delimiter is '|', msq);

Thank you!

View solution in original post

3 Replies
sunny_talwar

Is this from a CSV file?

Capture.PNG

microwin88x
Creator III
Creator III
Author

Yes! Just solved it by doing this:

LOAD Field1,Field2,Field3

FROM File.csv (txt, utf8, embedded labels, delimiter is '|', msq);

Thank you!

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

when you choose your file in edit script --> table files do this.

8-10-2016 12-15-06 PM.png