I have just started learning PAD and I suspect this question reflects a basic misunderstanding of how PAD deals with Excel data.
My first PAD sample takes the rows or one Excel file B and appends it to an existing file A, essentially adding new rows.
It is not a simple append, though, as the columns structure of the two files is not identical. Currently I read in the appropriate fields from B, and write each to its matching column in A.
Problems occur only in two areas:
1) When I need to transform a field value in B. For example, replacing a "-'" with a zero
2) Stopping the iteration when I reach a blank row in B.
In these cases, the circled conditions are never recognized
I suspect this is because PAD sees these two fields retrieved from Excel as tables, or perhaps there's a data typing issue. Both fields are typed as "general" in the Excel source file.
I'd welcome any advice, including RTFM (as long as you point me to the manual and, ideally, the chapter)
Thank you.
