Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

I have a requirement to run a report weekly, need to pull the data sql where clause create

Highlighted

1)I have a requirement to run a report weekly. I have tried to update the query builder with the following function createddate>=Date now -7 but did not work. I would really appreciate any help. Thank you

 

2)in the output.CSV how do i add pipe delimited  ||'"|"'||, I was able to add one pipe but not multiple pipe delimited.

 

3)output.csv, how do i update the date to .csv This report has to be generated every week. 

 

 

Highlighted
Alteryx Certified Partner

Hi @cloudcrmconsulting, referring to your questions

1) What database type are you using? Oracle or SQL server? Assuming you are looking to pull last 7 days worth of data and the database type is:

Oracle, I would try createddate >= SYSDATE-7 

SQL Server, I would try createddate >= GETDATE()-7

 

2) & 3) attached is a skeleton example of how I artificially create the .csv files output location and pass it to the Output tool, where I also define the | delimiter to be used

 

AbhilashR_0-1590010020619.png

 

 

Please let us know if this isn't what you were looking for.

 

Highlighted
I am using Salesforce. How to pull the records in where clause sysdate -7

--
Regards,
Praveen
Highlighted
Alteryx Certified Partner

LAST_N_DAYS in the following link seems like something you are looking for: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sel...

Labels