Concatenate column

[RKULKARNI4]

Hello Team,

I have one column example :"1231-M2005003681-AC-1-20200424-12477"

1231 : 1
M2005003681 : 2
AC : 3
1 : 4
20200424 : 5
12477 :6

I need to display only 2,3 & 4 only .How it can be done in Qliksense.Please advise.

Regards

RK

[Gui_Approbato · Accepted solution]

Hello,

You can use the Subfield function.

Subfield(Column, '-', 1 )   --> '-' is the delimiter, and 1 is the part that you want to grab from it.

[Kushal_Chawda]

@RKULKARNI4  there are many ways to do it. other way is like below

=mid(Field,index(Field,'-')+1,len(Field)-index(Field,'-',3))

[RKULKARNI4]

Thanks for the solution its worked for me