Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
1 year ago

Writing a inline ingestion command with more column values

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

kql database
kql queryset

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      pmscorca
      Icon for Post Prodigy rankPost Prodigy
      1 year ago

      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