Search found 10 matches
Search found 10 matches
Page 1 of 1
- by WallyD444
- Wed Sep 02, 2015 6:51 pm
- Forum: Community Forum
- Topic: Increment Variable by Row
- Replies: 1
- Views: 6611
I have a project that will concantenate a few columns to form a url, I need a unique value for each row. Currently I'm using the modify column task, but I can't figure out how to create a counter for the unique value. e.g.: column 1 column 2 column 3 column 4 www .testing.com/ 0001 www.testing.com/0...
- by WallyD444
- Tue Jul 14, 2015 11:26 am
- Forum: Community Forum
- Topic: isnumber Function
- Replies: 2
- Views: 6777
Perfect, thank you!!
- by WallyD444
- Mon Jul 13, 2015 1:57 pm
- Forum: Community Forum
- Topic: isnumber Function
- Replies: 2
- Views: 6777
Is there a comparable function to isnumber in GAD? I'm trying to base an if statement on whether the variable returned is a number (0-9), I've tried this: ${decimal(fnameChar)==1 OR decimal(fnameChar)==2 OR decimal(fnameChar)==3 OR decimal(fnameChar)==4 OR decimal(fnameChar)==5 OR decimal(fnameChar)...
- by WallyD444
- Thu Jul 02, 2015 12:08 pm
- Forum: Community Forum
- Topic: Check if a variable exists
- Replies: 12
- Views: 25088
Thanks Rick, that worked perfectly!
- by WallyD444
- Wed Jul 01, 2015 7:50 am
- Forum: Community Forum
- Topic: Check if a variable exists
- Replies: 12
- Views: 25088
I'm trying the same thing, I have a variable 'fileList' that is a filelist and I'm receiving this error: [8099 - Create File List] An unexpected error occurred. Function 'IsEmpty': Parameter '1' must be a string value. Function definition: 'IsEmpty(text) returns boolean' here is my XML: <project nam...
- by WallyD444
- Thu Mar 26, 2015 9:39 am
- Forum: Community Forum
- Topic: Spreadsheet with two title lines...
- Replies: 3
- Views: 9010
It may be a helpful feature in a future release to allow multiple titles, that way we can pass variables through without having to use a template.
- by WallyD444
- Mon Nov 17, 2014 4:49 pm
- Forum: Community Forum
- Topic: SQL Server Stored Proc Execution
- Replies: 4
- Views: 9177
Hi, I have GA Director 4.1.1, and it's giving an "Invalid SQL statement" error trying to execute a stored procedure: <project name="Database Exec Test1" mainModule="Main" version="2.0" logLevel="normal" threadSafe="true"> <module name="Main"> <sql label="DBConnection" resourceId="WORK" autoCommit="t...
- by WallyD444
- Fri Oct 03, 2014 7:40 am
- Forum: Community Forum
- Topic: Cannot get a text value from a error cell
- Replies: 3
- Views: 6706
- by WallyD444
- Thu Oct 02, 2014 8:45 am
- Forum: Community Forum
- Topic: Cannot get a text value from a error cell
- Replies: 3
- Views: 6706
I'm receiving the following error when converting a .xlsx file to .csv using the "Read Excel File" and "Write to CSV" tasks when the .xlsx file contains cells with value #N/A: "Cannot get a text value from a error cell" I've set "Skip Invalid Records" to "True", but that doesn' t help. Here is the p...
- by WallyD444
- Fri Sep 19, 2014 2:18 pm
- Forum: Community Forum
- Topic: Excel template fails
- Replies: 1
- Views: 4469
I have created a project that will select data from a table in an oracle DB and create an excel attachment and send it in an email. The job worked great, until I attempted to use a template. I had some data manipulation in the template, creating percentages from the gathered rows, however when I ran...
Search found 10 matches
Page 1 of 1