csv template with header

[Mark_Pathfinder]

Hi,@AleksiAlkio  i have an order capture where there are 2 tables, ORDER TABLE and ORDER DETAIL. I need to create a csv template with header for the related file. I inserted this string

<<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; "<<[Cod Art.]>>";"<<[Description]>>";"<<[Price]>>";"<<[Qta]>>";"<<[Note]>>"; <<End>><<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; "<<[Cod Art.]>>";"<<[Description]>>";"<<[Price]>>";"<<[Qta]>>";"<<[Note]>>"; <<End>>

But if i have 2 or more strings, the csv created whit more COD ART.;DESCRIPTION;PRICE;QTA;NOT  like that

[Mark_Pathfinder · Accepted solution]

SOLVED

The correct string is this

Cod Art.;Description;Price;Qta;Note; (is need to put the HEADER at first

<<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; "<<[Cod Art.]>>";"<<[Description]>>";"<<[Price]>>";"<<[Qta]>>";"<<[Note]>>"; <<End>><<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>>  "<<[Cod Art.]>>";"<<[Description]>>";"<<[Price]>>";"<<[Qta]>>";"<<[Note]>>"; <<End>>