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

Troubleshoot conversion errors

david20100
8 - Asteroid

HI,

 

I have a Date Table 

 

DateFiscal YearFiscal MonthFiscal Month2Fiscal Month3Fiscal Month4Fiscal PeriodFiscal DayCalYear
 19001JanvierJanJanuary0501900
2004-09-0120059SeptembreSepSeptember0112004
2004-09-0220059SeptembreSepSeptember0122004
2004-09-0320059SeptembreSepSeptember0132004
2004-09-0420059SeptembreSepSeptember0142004
2004-09-0520059SeptembreSepSeptember015

2004

 

And when i join that table with my invoice table on Date, i got this conversion error

 

conversion_errors.JPG

 

How can i go see record #328751 to see what is happening?

 

thanks

3 REPLIES 3
Nate1
8 - Asteroid

You can use the Select Records tool. Just enter the record ID in the configuration and it will pull back just that record for you.

 

 

DriveMyData
7 - Meteor

Hi David,

 

If you put a browse on your input tool, you will get numbers listed down the left hand side of the browse output. You will then be able to find your record.

 

Joe

anoopdk
7 - Meteor

This is the right thing to do, I had a similar challenges was able to find the specific records by using Select Record Tool.

Labels