Solved: Save File CSV - empty last row - Page 2

Fabian_Weller · 07-16-2020 01:07 AM

I use a Report to save a CSV. This is my txt template:

<<Start: ORDERBY(SELECT(TimeTracking[Key] , [Date] = TODAY()-1) , [Employee_In] , FALSE , [In])>>
<<[Employee_In]>>;1;<<TEXT([Date],"dd.mm.yyyy")&" "&[In]>>;3;2
<<End>>
<<Start: ORDERBY(SELECT(TimeTracking[Key] , [Date] = TODAY()-1) , [Employee_In] , FALSE , [In])>>
<<[Employee_In]>>;1;<<TEXT([Date],"dd.mm.yyyy")&" "&[Out]>>;3;2
<<End>>

This is working perfectly. But: I always get an empty last row:

How can I get rid of that empty row?
We import this CSV file in our system and it’s getting confused because of this empty row

Fabian_Weller

@Bahbus Thank you very much for that hint. I found a workaround to get rid of the empty row.

<<Start: ORDERBY(SELECT(TimeTracking[Key] , [Date] = TODAY()-1) , [Employee_In] , FALSE , [In])>>
<<[Employee_In]>>;1;<<TEXT([Date],"dd.mm.yyyy")&" "&[In]>>;3;2
<<End>>
<<Start: TOP(ORDERBY(SELECT(TimeTracking[Key] , [Date] = TODAY()-1) , [Employee_In] , FALSE , [In]),
COUNT(SELECT(TimeTracking[Key] , [Date] = TODAY()-1))-1)>>
<<[Employee_In]>>;1;<<TEXT([Date],"dd.mm.yyyy")&" "&[Out]>>;3;2
<<End>>
<<Start: LIST(INDEX(ORDERBY(SELECT(TimeTracking[Key] , [Date] = TODAY()-1) , [Employee_In] , FALSE , [In]),
COUNT(SELECT(TimeTracking[Key] , [Date] = TODAY()-1))))>>
<<[Employee_In]>>;1;<<TEXT([Date],"dd.mm.yyyy")&" "&[Out]>>;3;2<<End>>

The middle part produces all rows, except the last row.

The last part produces only the last row.
By putting the <<End>> tag directly to the end, it will not produce a new line.

@Steve should I report this to AppSheet support so they could fix this “adding a new line” bug?

View solution in original post