I am working on the above workflow and I am running into an issue with the join. I've narrowed this down to the data types. The data in the left join is v_string, while that in the right join is double. I tried changing the data type on the double to v_string but noticed within the input tool that the data is being brought in without the leading zeroes. Therefore, changing to v_string isn't helping since the input data is wrong. How can I get the data into the input tool with the leading zeroes?
Also, the data type in the excel is "Special" I've tried changing it to "text", "general" etc. but these changes within excel all remove the leading zeroes. Not sure why this is happening since the data type in the top inputs are all text in the .xlxs and the leading zeroes are not deleted when I input. Please help.
