Add custom column in output

[azure]

Add custom column in output

[lokesh-zende]

I did something like this.
Declare a variable and assign datetime value in desired format to that variable.
Then use that variable with the result received by extracting a .tsv.

DECLARE @Date = DateTime.Now.ToString("yyyyMMddHHmm");

@Result = 
    EXTRACT 
            User_ID int,
            First_Name string,
            Middle_Name string,
            Last_Name string,
            Age int,
            Gender string,
            Team string
        FROM "/Users.tsv"
        USING Extractors.Tsv();

@Final = SELECT *, @Date AS Date FROM @Result;

OUTPUT @Final
TO "/UsersConverted.csv"
USING Outputters.Csv();

Though it works, I would like to know if there are any other ways to achieve this.

[MikeRys]

If you want to add a single value to all the rows, your approach is probably the best one. You could write a custom extractor but that is too much overhead. If you have more values that you want to add depending on a value in the file, create a constant table (with SELECT FROM VALUES) and join it with the result of the extraction.

If this answers your question, please close this issue.