add new field within same load

Wed, 23 Jul 2025 14:48:52 GMT

I need help to create new field using variable from loaded table.

I have many loaded table that contains the same variable and i want to create new field calculated with this variables.

I try this but it doesn't work

Load *,

Nom&' '&Nom1 as [Nom Prénom],

if([Maternité (Évènements)]=1,Date(Date)) as mindate,

if (left(Badgeages,3)='...'and mid(Badgeages,5,1)<> 'T',mid(Badgeages,5,1)) as entrée,

if (left(Badgeages,3)='...' and mid(Right(Badgeages,11),1,3)='...',mid(Right(Badgeages,7),1,1)) as sortie,

if(match([Code d'entreprise],'5'),'SOUSSANA','Autres')as Société;

topic add new field within same load in Archived Groups