O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data as text

Tabular modeling natively supports the import of files with extensions of text (.txt), comma separated values (.csv), and tab separated values (.tab). Once a file to import has been defined, the user can specify the delimiter (column separator), and the importing interface scans the file to estimate the underlying data types for each column. Finally, the interface finishes the import process by loading the data according to this specification.

Getting ready

A text file to simulate the output file for the sales record header has been created and is available from the online resources for this chapter. This file includes the sales_order_id, customer_id, employee_id, currency_id, customer_po_id, sales_territory_id, order_dt

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required