How to debug a transform script?

[Anonymous]

When I try to Apply my load and transform script, I get the following error:

So, I understand that there is something somewhere that can't be converted to a number, but what is it? Which column and row?

How does one debug this sort of thing?

Thanks in advance.

Gzzzt

[Anonymous]

Thanks. That did enable me to fix the problem. I had code that was a numeric character in the top 1,000 rows but later on contained alpha chartacters. 

However to find it, I had to go through the columns one at a time. Is there a way to make it tell me which of the columns had a problem?

[Vijay_A_Verma · Accepted solution]

In PQ screen, View menu - Check column Quality - Here you can see if any column is having errors.

Screen preview is limited to 1000 rows not to entire dataset, hence errors may not be getting reported.

At the down below, click Column profiling based on top 1000 rows and change it to entire data set.

Now check for errors.