Schema rearranging in tmap component

[SPrathipati]

Currently using the 'Talend open studio for data integration'. My team and I are facing the following issue,

the input schema in tmap shuffles up once you save and open the job the again, which causes mismatch and errors while running the job. Any help on how to fix this issue is much appreciated. Thanks in advance.

[Anonymous]

Can you show us some screenshots of what you are experiencing here? I don't believe I have seen this issue

[SPrathipati]

this is the starting order of schema which was manually entered into tmap. (I do not have the original schema screenshot since it's already rearranged, but it was of same order as the select query in tDBinput)

----------------------------------------------------

That automatically got rearranged to this when I reopened the job

[gjeremy1617088143]

Hi @Siddhartha Prathipati​ , it's a wellknown bug on the 7.1 and 7.2.1 , it was fixed since 7.2.2 , on 7.1 you can use metadata to force the schema and when you want to change the schema you pass by the metadata it's the only workaround i know on this version.

Send me love and kudos

[SPrathipati]

we are currently on 7.2.1 version of open studio, so upgrading is the only fix?

[gjeremy1617088143]

go to 7.2.2 or 7.3 , or use metadata

[SPrathipati]

Thanks lot @guenneguez jeremy​ .

[gjeremy1617088143]

you can use generic schema in metadata to force the order

[Anonymous]

Sorry, I misunderstood the issue here. Thanks @guenneguez jeremy​ for answering this.