Given the following datasource of reservations, …we want to create a table with column A being the name, and column B being the number of tables. However, sometimes the name is missing for the reservation, and we need to make sure that column A is not misaligned to column B. What formula would we use to do this?

Advertisement

  • @/reservations/name
  • SELECT ( @/reservations/name, @/reservations/name !=BLANK() )
  • IF ( @/reservations/name !=BLANK(), @/reservations/name, BLANK() )
  • @kf:fill_elements(/reservations, ‘name’)
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

We respect your privacy and take protecting it seriously

Leave a Comment


Share via
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

We respect your privacy and take protecting it seriously

Send this to a friend