CODEWITHSUNDEEP
azure-data-lakeu-sql
user3843858
user3843858

Reputation: 331

Multiple directories with multiple files in U-SQL without date time

i want to read multiple files from multiple folder using U-SQL without date time. folder structure is

input input1 file1.csv file2.csv input2 file3.csv

Upvotes: 2

Views: 633

Answers (2)

wBob
wBob

Reputation: 14389

Jamil's answer will work. If you want more control, you can simply list the files you want as a comma separated list, eg

@data =
    EXTRACT col1 int,
            col2 int,
            col3 int,
            col4 int
    FROM "input/input1/file1.csv",
         "input/input1/file2.csv",
         "input/input2/file3.csv"
    USING Extractors.Csv();

Upvotes: 0

Jamil
Jamil

Reputation: 858

You can try this: 

@"input/input{*}/file{*}.csv"

Upvotes: 3

Related Questions