Reduced text in column when merging datasets

[Sapna_Chopra]

Hi Guys,I have a data set which has questions and answers from a survey but when I merge this dataset with another dataset based on ID, I get incomplete text for each question.Could you advise the reason behind this.

Thanks 

Sapna

[vanessafvg]

@Sapna_Chopra  can you please explain a bit more how you are doing this?    How much text is in each answer?

[Sapna_Chopra]

Hi Vanessa,

Before merging the datasets the length of  each question(which is each a column of yes/no) was  even more than 200 charecters (the questions are long) but when I merged this questionnaire dataset with another dataset based on ID,the length of questions are now restricted to 80. The dataset merges fine but I dont know the reason behind this decrease in  length

Thanks