question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

Copy Activity in ADF using a pipe delimited file with no headers? Please assist

Hello! @nasreen-akter @MartinJaffer-MSFT

We have a pipe delimited file with no headers....I am trying the auto-create for the Sink Table. The source is a json file. It won't let me auto create a table. Is it due to no headers? How can I get this data into a Table so that I can manipulate the data in the Table?
Thanks !!
Mike Kiser

86352-image.png


azure-data-factory
image.png (4.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered ewinkiser commented

Hi @ewinkiser,

If you add the schema into the CSV datatset, that will help. :)

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @nasreen-akter

RIght on!! It worked......thanks SO much!
Mike Kiser

0 Votes 0 ·