Field data type changes based on Input file

Hi Team,

I'm using 2 sets of input files and perfuming a join. Now I'm performing a join on a column(EmpId) and before I join, I change the data type to V_string using a select tool. Now for one set of input everything works fine. Problem is when I receive another set of input for the same files the datatype changes to double and throws an join error at the join tool saying "string fields can only be joined to string fields.

My query is why is the datatype changing to double when I'm selecting V_string as datatype in the select tool.

Appreciate any help. Thanks in advance.

Common Use Cases

Accepted answers

atcodedog05

Hi @hemant86

Let me know if that works. If yes you can mark my response as a solution if no let me know the issue.

Happy to help : )

All comments

atcodedog05

Hi @hemant86

Use a select tool and force the datype to v_string: forced like below. This way it will always be v_string and will join.

Hope this helps : )

hemant86

Thanks @atcodedog05 . I guess V_String: Forced appears as an option only when the initial input is string. Now I see only Double: forced. Since my 1st input has only Double: Forced and 2nd input has only V_string: Forced, not sure how to proceed about this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703