Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

String to Date when extracting to excel

sahartz
8 - Asteroid

Hi,

 

I have a format that I need to keep when the data is String (due to the first lines).

I am extracting this data to excel and I need the dates to be in Date format and not string.

Is there a way to do that?

sahartz_0-1622381457324.png

 

Thanks,

Sahar

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @sahartz 

 

Here is a way how you can do it. The trick is to output the headers anything above col name separately(in your case Original Due Date) and table with headers separately (Col name and data)

 

1. Make sure the line above header is executed first and in output tool you have checked skip field names

atcodedog05_1-1622382056729.png

2. Now for writing the actual data table you need to mention range from A2:ZZ99999 (2nd row to estimated max range) while setting the sheet name. Once you have set it will reflect in the path. This the table is written from row 2 and data type wont be affected.

atcodedog05_2-1622382195928.png

3. Make sure both write options are set to overwrite sheet.

 

Output:

atcodedog05_3-1622382278577.png

 

Hope this helps 🙂

sahartz
8 - Asteroid

Hi @atcodedog05 

Thanks!!!! I managed to include all the data in the excel.

1 last question, do you know how can I change the date so the year will be 4 digits and not only 2 ?

atcodedog05
22 - Nova
22 - Nova

Hi @sahartz 

 

Just a rough guess can you change zz to ZZ in the sheetname range in the below configuration.

atcodedog05_0-1622470988906.png

 

atcodedog05
22 - Nova
22 - Nova

I guess you figured it out @sahartz 🙂

atcodedog05
22 - Nova
22 - Nova

Hi @sahartz 

 

That is purely your excel format. What you can do is you set the date formatting in the excels column cells in advance. And use output tool with preserve output formatting like below. This way it takes the existing formatting.

atcodedog05_0-1622471357915.png

 

Hope this helps 🙂

 

Labels