Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes! Just solved it by doing this:
LOAD Field1,Field2,Field3
FROM File.csv (txt, utf8, embedded labels, delimiter is '|', msq);
Thank you!
Is this from a CSV file?
Yes! Just solved it by doing this:
LOAD Field1,Field2,Field3
FROM File.csv (txt, utf8, embedded labels, delimiter is '|', msq);
Thank you!
when you choose your file in edit script --> table files do this.