Your packaged workbook is prompting to connect to a database. Can you re-save it as a packaged workbook and re-attach?
The file I attached is a twbx file. I re-tested it again, and it doesn't prompt for a connect to db.
In CSV zip file, you have only Zip Code.
And Zip Left (Zip Code) is already there in Account file.
Then why you need to join these two data source..?
Can you please clarify that..?
BTW, I have just converted Data Type of Zip Left from String to Whole number and view has been changed into sheet. Please see below Image
Please check if it helps you.
I was able to get in by taking apart the packaged workbook. The problem is that Zip Left is a string and Zip Code is a number. If you hover over the join where you see the exclamation, it will show you the error.
You need to click on the field and change it to a string.
After doing that, the join should work as expected.
I did see the error was related to string vs number and changed the zip left to a number. It didn't work for me though I attempted a couple times. I'll re-attempt. Thank you.
Have you tried mine workbook which I have attached below..?
Okay, maybe you can share a screenshot or a packaged workbook where you've tried to connect the two.
Please post your question.
Thank you for stepping me through process, as I apparently did not execute properly the change of number to string. It is a step toward my original question, which is to generate a list of all postal codes with # of accounts in each. If there are no accounts in a postal code, I still wish to include it in my list with 0 # of accounts.
I think it is a right join where I want ALL zip codes regardless if there are accounts in the zip code. But when I generate the list, 92661 for example doesn't show up with the # of accounts in that zip = 0.