Skip to Content
0

Duplicated table empty field

Jul 10, 2017 at 10:27 AM

25

avatar image

Hello guys.

i have one big problem.

I am generating table and some fields are duplicated with a second empty value.

Duplicated only completed field..

My sample:

=If [Create Date] Between(ToDate(FormatDate(RelativeDate(CurrentDate();-11);"dd-MM-yyyy")+" 00:00:00";"dd-MM-yyyy hh:mm:ss");ToDate(FormatDate(RelativeDate(CurrentDate();-11);"dd-MM-yyyy")+" 08:00:00";"dd-MM-yyyy hh:mm:ss")) Then [Status Job]

WHY?!

10 |10000 characters needed characters left characters exceeded

can you share the data screenshot

0

Thanks for you help, Amit!

1123.png (32.0 kB)
0

IN this table must be only distinct AC and Stand. If i add new column with sample, count of AC and stand are duplicated.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers