Question

Query Excel spreadsheet issue

Workflow

Updated October 28, 2016

asked on October 28, 2016

Im trying to figure out why Workflow will return all results just fine except the one that contains 135C.

I can attache the actual spreadsheet if necessary, but here is a screen grab.

Workflow finds the entry in the left column, and returns the result in the right.

0 0

Answer

SELECTED ANSWER

replied on October 28, 2016

This is a known issue in Excel. Excel internally determines the data types of columns based on the data in them (by looking at the first 8 rows by default). This determination has nothing to do with the column type specified in the spreadsheet through the user interface, that one is just for display in Excel.

For data not matching the column's data type, Excel returns null values to the ODBC driver.

You can try a custom connection and the Import Mode settings mentioned in this article.

1 0

replied on October 28, 2016

Ok, thanks. I think the easiest solution for me would be to just use a conditional decision in this case. If its Pasco, run a branch with an assign field value operation to enter the 135C, everything else query's the spread sheet.

0 0

Replies

replied on October 28, 2016

Assuming you are querying on the Jurisdiction, have you checked to see that there aren't any weird characters or white space after the Pasco County text?

0 0

replied on October 28, 2016

No, nothing there. Here is the spreadsheet. Nothing special...

windzones.xlsx (10.47 KB)

| Download

0 0

You are not allowed to follow up in this post.

Question

Question

Query Excel spreadsheet issue

Answer

Replies

Sign in to reply to this post.