Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create new column from Data coming from Different columns

Hi Experts,    I would like to create a column in power query picking up data from other columns on which some columns the Data format is ready but for other columns I have to use search/find formu...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

The second and third last entries do not follow the rules that you have set.  There is no LU there in the Job3 column.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ashish,

 

The data are generated like this, thats why in excel i use this formula :

MID(Data[@[Labour Contract]],FIND("#",Data[@[Labour Contract]])+1,(FIND("-",Data[@[Labour Contract]]))-FIND("#",Data[@[Labour Contract]])-1) just to extract he Characters: LU####. 

The same with Job3 :"LU"& [Job3].

 

Thank you.