Flat Files

[#1]

How to Connect Flat  Files In BI Script ? Anyone Example?

[sibin_jacob]

Hi Nanda,

You can use the below script to load data from a text file.

Directory;
LOAD Date_Id,
    Physician_Id,
    Site_Id,
    Geo_Id,
    #New_Patients
FROM
Test.txt
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Please find the attached sample text file.

Thanks,

Sibin Jacob.C