Writing a inline ingestion command with more column values

[pmscorca]

Hi,

I'd like to write an inline ingestion command with more column values, similar at this:

.ingest inline into table mytable <|
columnvalue1, /* columnname as a comment */
columnvalue2, /* columnname as a comment */
...
columnvaluen, /* columnname as a comment */

I'd like to write each column value on a new line and with the column name as a comment.

It seems that I need to write all column values in a single line using the comma as a separator without indicating any comments.

Any suggests to me? Thanks

[v-tangjie-msft]

Hi @pmscorca ,

Refer this document, use the two slashes (//) to add comments.

Refer this document, you can ingesting data into a table with multiple columns.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[pmscorca]

Hi, thanks for your reply but I've already read the suggested articles.

I cannot use the two slashes to add a comment in .ingest inline command.

I'd like to write, if possible, each column value on a new line and not all values on a single row.

So, I repeat my requirement as already posted. Thanks