Marc_H

User06053, Not sure if you figured this out, but the CSV Advanced should solve your problems. Warm regards, MH

in Is there any way to connect to an FTP/SFTP server in a custom connector? Comment by Marc_H May 2018

Give this a try. You'll have to replace the inners with the fields from your database. I didn't build the code with optimization in mind, so you're welcome to tweak it as needed. CONCAT( CASE WHEN LENGTH(CONCAT('',ROUND(Sum(`SALES`), 0))) > 9 THEN CONCAT('$', CASE WHEN LENGTH(CONCAT('',ROUND(Sum(`SALES`), 0))) = 12 THEN…

in How do I put a comma in multiple summary numbers? Comment by Marc_H April 2018

Hi, User05404, Can you give Valiant and I a sample from your ZIP column in the ODBC data set you're using? What you can try is convert your string ZIP column into a Whole Number and join it on ZIP from Zips2Fips data set - assuming your ZIP column from ODBC data set is 5 char. I haven't tested this, so please keep us…

in Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet Comment by Marc_H January 2018

Hi, User05404, Without seeing the file itself; the only thing I could recommend is check the type of data you're trying to join. Are they the same data type? Same length? etc... Best wishes, Marc Ha

in Creating New DataFlow from Zips2Fips DataSet and ODBC DataSet Comment by Marc_H January 2018

Hi, Swagner, Hopefully this is of use for you. - Filter into two tables based on the criteria you mentioned below. - Add Constant 'SQD' or whatever constant you're going to replace your Supplier ID with. (You have to do it for both tables so you can append at the end.) - Set column value from your Constant column to…

in Magic ETL Help - Overwrite value in a column if another column equals one of two values Comment by Marc_H January 2018

Hi, John, I'm a little confused. Isn't what you're wanting already calculated in Column E - Duration? If we look closely at what you're wanting for Friday: Sample: 1) Starting on Friday, the time elapsed between the end of their "Offline" status in row 32 (END TIME on 11/2/17 at 7:56am) to their first "On a Call" status in…

in Calculating time increment/differences between Agent Statuses & variance between them Comment by Marc_H January 2018

Hi, Xerva, I'm looking for a solution on our participant tier access level to be able to do this. I need them to export the full table without having to remove our 50 limiter. Warm regards, Marc H.

in Table Export Comment by Marc_H January 2018

xx

in Date Difference contingent on other column values SQL Comment by Marc_H January 2018

Hi, GuitarHero, I might be simpilfying this question, but would nesting your formula in a CASE statement give you what you need? Best wishes, Marc H.

in Create a Letter Grade or Number Grade Based on Multiple Fields Comment by Marc_H January 2018

Hi, Swagner, I had a chance to play with ETL today and got something put together. Hopefully this will give you what you need; if not, give you some ideas. - The Date - Current is just using the Date Operations to give you a value. This will indicate how many 'Days until Date'. Take your 'Last Update' field (-) Current…

in Magic ETL - Add a "Flag" column based on comparing a date in one column to current date Comment by Marc_H January 2018

Hi, Swagner, ---From an Excel formula standpoint, it would be: =IF([@[Last Update]]>TODAY(),"Future","Past")--- If you're willing to go the BEASTMODE route; you can create a flag column by using the CASE function. - This is assuming the field 'Last Update' is a DATE field. CASE WHEN `LAST UPDATE` > CURRENT_DATE() THEN…

in Magic ETL - Add a "Flag" column based on comparing a date in one column to current date Comment by Marc_H January 2018

Marc_H Member

Comments