Skip to main content
Question

CONCAT with date

  • October 8, 2020
  • 2 replies
  • 33 views
D
Level 5
Hi all, I want to compare/concat a string (e.g. SupplierName) with a date/day. Target: Are there days where I have used more than 5 suppliers. My formula suggestion: FILTER COUNT(DISTINCT SupplierName||Date)>5; Nay ideas? Many thx and br Daniel

2 replies

J
Level 0
  • justin.stegm
  • Level 0
  • November 22, 2021

Hi @Daniel Diers,

 

you have to both formats to be of the same data types. Probably you simply have to transform the data into a STRING. If you have already tested some PQL statements to do that, it would be great if you could share them here and we work on them together!

 

Best,

 

Justin

gabriel.okaba11
Celonaut
Forum|alt.badge.img+2

Hey Daniel,

you cannot apply a filter directly into an aggregation such as FILTER COUNT() > 5 but you can use pull-up functions.

You can use a similar example provided below

FILTER PU_COUNT_DISTINCT("ParentTable", "Table"."SupplierName"||

TO_STRING("Table"."Date", FORMAT ( '%m-%d-%Y, %H,%M,%S' ))

) > 5;

Best,

Gabriel

Gabe
Community Code of ConductAccessibility statement