Is there any way to Drag and Concatenate more than one SQL Field by Drag and Drop(Auto mode) in Data

Malav Shelat

Hello Team,

 

Happy New year,

 

now my question is,

i have 2 SQL fields FirstName and Lastname, 

I have created Just one Entity called 'Name'

Now i want to concatenate SQL fields FirstName and LastName (FirstName + LastName = Name) and append it to my entity Name

lets say if i do not want to use manual option for this, so is there any way this can be done via Drag and Drop in Auto Mode itself in Data Reader.

 

Much Thanks,

 

Regards,

Malav

Alexander Kappes

Dear Malav Shelat,

 

only thing you can do is inserting the first field with drag and drop. The second has to be inserted "manualy".

 

You can write it manually into the sql field.

 

 

A little way to easy up this is using another entity (just temporarily during the configuration), inserting the second sql column into this and using (CTRL+C & CTRL + V) function.

 

Using this, please don´t forget to remove the additional entity when your reader configuration is finished.

 

Hope it helps

 

regards

 

Alexander Kappes

Previous Member

Hi, Alexander Kappes True, I follow the same process but just wanted to confirm that i am not missing any functionality pre-designed for this requirement, 

 

Thank you!