-
Syntax Error when using beast mode to create Case Statement for data flow
I received syntax error message `Invalid Formula : A column in this calculation did not exist` when trying to create a Case Statment (below) for a data flow. CASE WHEN `CaseCreatedBy` LIKE `%# Svc-ShipwiretoIM360integration%` THEN `true` Else `false` END
-
Limitations on Data Fusion for data manipulations
I have been playing around with all the features available in Data Fusion and it seems like not only it's difficult to understand what function can go after what, and more importantly, a limitation on joining multiple linked functions within one workflow or to build a more complex workflow. Can we have the Data Fusion…
-
create a comma-separated string from multiple rows
If you think of it, it's basically reverse engineer the process of "splitting a string into multiple rows". I have a long list of values that are already split into different rows from the original data source, but now I want to put them back in a single string, separated by the commas. How do I do that? my data is…