title: U-SQL: Schematized input files
body: <p>How can I use schematized input files in an U-SQL script? That is, how can I use multiple files as input to an EXTRACT clause?</p>
  
  <p>According to </p>
  
  <p><a href="https://msdn.microsoft.com/en-us/library/azure/mt621320.aspx?f=255&amp;MSPPError=-2147217396" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/azure/mt621320.aspx?f=255&amp;MSPPError=-2147217396</a></p>
  
  <p>and</p>
  
  <p><a href="https://social.msdn.microsoft.com/Forums/en-US/0ad563d8-677c-46e7-bb3e-e1627025f2e9/read-data-from-multiple-files-and-folder-using-usql?forum=AzureDataLake&amp;prof=required" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/en-US/0ad563d8-677c-46e7-bb3e-e1627025f2e9/read-data-from-multiple-files-and-folder-using-usql?forum=AzureDataLake&amp;prof=required</a></p>
  
  <p>I tried both</p>
  
  <pre><code>@rs =
      EXTRACT s_type string, s_filename string
      FROM "/Samples/logs/{s_filename:*}.txt"
      USING Extractors.Tsv();
  </code></pre>
  
  <p>and</p>
  
  <pre><code>@rs =
      EXTRACT s_type string
      FROM "/Samples/logs/{*}.txt"
      USING Extractors.Tsv();
  </code></pre>
  
  <p>Both versions resulting in an error message complaining about '*' being an invalid character.</p>
  
  <p><a href="https://i.stack.imgur.com/3FhMj.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3FhMj.jpg" alt="U-SQL error message"></a></p>