Merge Query leads to data type error

Anonymous · ‎03-24-2022

Hello community,

My organization has two tables that I am using for a financial dashboard (AR and AP), and my team is trying to merge the queries based on two ID's.

One ID is a concatenation of text fields and is working fine. The other is product IDs, which are mostly whole numbers, with a few letters added on occasion (ex: 9015, and G016). Standard practice is to set the product ID to text, which I did prior to the merge.

Once I merge and expand the table, I receive a data type error on my product ID, which reads like this:

"DataFormat.Error. We couldn't convert to Number. Details: G016"

Why is it converting a field I set to text into a number during the merge? And how do I solve this problem?

Any help would be greatly appreciated.
Thanks!

Anonymous · ‎03-24-2022

Check that your parameters have commas in the correct place, as well as your braces. Since joins can take a whole number in the JoinAlgorithm parameter, you may have 4 commas in your Merge function, which would be expecting a 1-6 or a JoinAlgorithm.Whatever value. Check your commas--I bet that's it!

--Nate