Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Troubleshoot conversion errors

Highlighted
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

Highlighted
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.

 

 

Highlighted
Alteryx Partner

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

Highlighted
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