Stack Overflow
Stack Overflow

Questions tagged [expressionbuilder]

95 questions
0
votes
1 answer

Can a SSIS variable have a SSIS expression as its value?

I have a variable "variable1" defined with SSIS expression as its value. Is there a way to evaluate the "variable1" as expression in a second variable "variable2"? For example, variable1 is as below: When I evaluate variable2 by adding the…
maljee
  • 21
  • 4
0
votes
3 answers

How to replace a column result if null with another column result in BIRT

I would really appreciate some help with a computed column using an expression in Birt. I have two columns which are giving results, one gives email addresses and one gives contact numbers: telephone, mobile.. When the email result is null then the…
TheOx
  • 67
  • 7
0
votes
1 answer

How do you return a value within a 2D array in Azure Data Flows Open Expression Builder?

Background: I have a CSV file with a column that has a list of tags for a given row. The tag list is not in any specific order and varies for each cell in the tags column. I am looking for the value for a row which matches the string "Owner". When…
theIntern890
  • 1
0
votes
2 answers

two expressions in one expression builder in ADF

Can we use two expressions in expression builder in data factory? For example: If I have a string column and I would like to to have two expression in expression builder. the two conditions are: if a value is empty then return space '' or if a value…
user2841795
  • 375
  • 3
  • 10
  • 25
0
votes
1 answer

Column to check if it has integer value or not using ADF Expression Builder

I have a string column called (Code) which will always have an integer value. I want to check if a Code column got Integer data put the source value, but if Code got string value in it then put 'Invalid' in Code column. Checker column will provide…
user2841795
  • 375
  • 3
  • 10
  • 25
0
votes
1 answer

How do I extract a file name from the filepath column using ADF expression builder?

I would like to get filename from below path using Visual expression builder in dataflow derived column in data factory. /datafactory/raw/files/filename.csv every row has got filepath. So filename is required in every row.
user2841795
  • 375
  • 3
  • 10
  • 25
0
votes
1 answer

How to use expression builder to create a file name with date even for the first day of the month

I have an SSIS package that runs each morning to pull the previous days file from an FTP server. I am using the code below to create the file name using the previous date. Everything works great with this except when today's date is the first day…
dlmcdanl
  • 1
0
votes
1 answer

BIRT - How to insert different data set rows in different places in a single text element

I'm developing a BIRT report and this is my situation. I have one text element, let's say this: blue square: 111 blue triangle: 222 red circle: 333 At the moment is static, and always displays the numbers you see. I would like to make the numbers…
jackscorrow
  • 682
  • 1
  • 9
  • 27
0
votes
1 answer

Azure Data flow convert null to whitespace/blank

I am using an expression builder in derived column action of Azure data factory. I have an iif statement that that adds objects to a single array of objects based on whether 5 columns are null. Within the iif statement if the object is not null it…
Dimeji Olayinka
  • 71
  • 3
  • 12
0
votes
1 answer

Is there where to do line breaks in the expression builder of azure data flow?

I am using the Expression Builder of Derived Column setting of the Azure Data Flow Activity. I am trying to code ac line break. So it looks like: Value1 Value2 What is the syntax to code this?
Dimeji Olayinka
  • 71
  • 3
  • 12
0
votes
1 answer

How to Mock global operators in JQuery Query Builder?

I am trying to build a page using querybuilder.js where I will build an expression and convert it into JSON rule. Below is my app.js file var valuesJson = [ {'operand1': 'operand1'}, {'operand2':…
JG1991
  • 143
  • 3
  • 14
0
votes
1 answer

How to create a calculated column in access 2013 to detect duplicates

I'm recreating a tool I made in Excel as it's getting bigger and performance is getting out of hand. The issue is that I only have MS Access 2013 on my work laptop and I'm fairly new to the Expression Builder in Access 2013, which has a very limited…
Jacko
  • 88
  • 12
0
votes
1 answer

ColumnHistory of a table field within a form

I am attempting to utilize an idea I have found within an Access template listed as "Asset Tracking." One of the forms, Asset Details, has a comment tab with two fields, New Comments (which is associated with a comments field in the sourced table),…
Chris F
  • 59
  • 7
0
votes
0 answers

Add contains method on custom object to work with LINQ

I have a class with a property that contains serialized data in json format: public class MyObject { public string SerializedData { get { ... } set { ... } } } The…
Sun
  • 4,458
  • 14
  • 66
  • 108
0
votes
1 answer

Access expression: Counting unique values in multiple columns

How can I use MS Access Expression to count unique values in multiple columns as shown below? I used Countif in Excel to get the "Yes" counts in the status column and now I want to use MS Access expression to get the same results.
Sun Light
  • 3
  • 1
1 2 3
4
5 6 7