Icon

230928_​PBSA_​DQ_​v1

No Rooms vs. Monthly EUR Avg.
VAT INCL. vs VAT OPT
SQL
Utilities INCL. vs Utilities OPT
DQ003 If No of rooms like "n/a" then Price/Room Monthly EUR AVG > 0 or like "n/a"
Python Script
DQ002 If No of rooms==0 then Price/Room Monthly EUR AVG like "not on offer"
Python Script
DQ005 'VAT INCL is "NO" but VAT OPT is not %'
Python Script
DQ004 'VAT INCL is "YES" but VAT OPT is different than "NO"'
Python Script
Concatenate
Address
Column Comparator
Row Filter (deprecated)
DQ006 'Utilities INCL is YES but Utilities OPT is different than NO'
Python Script
Concatenate
Duplicate Row Filter
Concatenate
DQ007 'Utilities INCL is NO but Utilities OPT is not price'
Python Script
Concatenate
Excel Writer
SQL File
Excel Reader
Excel Writer
Type
Column Comparator
Joiner
Provider
Column Comparator
Filter only Last referenctial Year
Python Script
Row Filter (deprecated)
Joiner
Row Filter (deprecated)
Excel File
Excel Reader
Column Filter
Name
Column Comparator
DQ012 Double room Monthly Local Avg is chaper than Single room Monthly Local Avg Double En-suite Monthly Local Avg is cheaper than En-suite Monthly Local Avg Double Studio Monthly Local Avg is cheaper than Studio Monthly Local Avg
Python Script
DQ011 single room chaper than single ensuite single ensuite cheaper than studio studio cheaper than 1 bedroom apt 1 bedroom apt cheaper than 2 bedroom apt
Python Script
Row Filter (deprecated)
String Manipulation (Multi Column)
Row Filter (deprecated)
Concatenate
Row Filter (deprecated)
String Manipulation (Multi Column)
Type
Column Comparator
String Manipulation (Multi Column)
Concatenate
DQ001 If No of rooms >0 then Price/Room Monthly EUR AVG > 0 or like "n/a"
Python Script
Provider
Column Comparator

Nodes

Extensions

Links