Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Concatenate

Hello All,   I need help to Concatenate three columns into one field.   Note Table ='Aquisition- On and ROC' Field 1 = 'Aquisition- On and ROC'[OntROC] Field 2 = 'Aquisition- On and ROC'[CurrN...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous 

    You can use CONCATENATE() function.

    e.g 

    Column = CONCATENATE([PriNewFunded]&"-"&[OntROC],"-"&[CurrNewFunded])

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous 

You can use CONCATENATE() function.

e.g 

Column = CONCATENATE([PriNewFunded]&"-"&[OntROC],"-"&[CurrNewFunded])

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you . I really appreciate it